Complex Iff

[Minty]

You can't paste them in on this forum I'm afraid.
You have to upload them in the advanced editor.

[dmyoungsal]

[dmyoungsal]

this is an extra field I created just to show the contents of the txtQtyYN field. As you can see, it too shows the same #Name! error

[Gicu]

Because you are missing the double-quotes around the field name (and you don't need to enclose it in square brackets if it doesn't have a space or other special character)...

[dmyoungsal]

thank you for your patience... It is now working like it needs to

[Gicu]

Great to hear, good luck with your project!

[CJ_London]

You can't paste them in on this forum I'm afraid.
You have to upload them in the advanced editor.

not sure that is quite correct.

1. Copy your image (ctrl C) - or use the snipping tool
2. click on the Insert Image button (4th in from the right),
3. select choose file on the From Computer tab

4. select clipboard

5. click on upload files

[Micron]

Funny, I don't get those options. Dialog looks much the same except it says
Browse... and No File Selected, not
Choose File... and No file chosen
and I get no clipboard option.

[CJ_London]

strange - I'm using the Opera browser. Just tried Edge and Chrome - and I get what you get