If then question
Hello everyone! Time for me to learn something new.
I've got a db that lists compostable tableware products (plates, bowls, etc), that will break down eventually into natural ingredients. I've got a multiple choice field to specify whether the unit type is inches, mm, or n/a. I'd like to be able to take the number field and the unit type field and create a composite. For example, a 7" wide plate would have a 7 in the number field and choose the "inches" option in the multiple choice field. But I might want to display that result elsewhere as [7"].
I tried this:
if unit_type_2 = inches then """
but it appears to have a problem with the "then" statement.
TIA for any thoughts on this.
2 replies
-
Easiest solution would be to use "in". Since you use "mm" why not continue to use letters.
If you must use the double quote then you can try:
let dquote := urlDecode("%22"); numberfield + dquote%22 is the code for double quotes, so we put that into a variable so we can use it later.
-
Thanks! I'll give that a try.
Content aside
- 1 yr agoLast active
- 2Replies
- 55Views
-
2
Following