Is there a function similar to COALESCE?
回答済みI'm using conditional fields in all of my forms which works nicely but i'm running into a problem while reporting. Structure is:
Form1
Field
SubField
Example if I have a form call Entertainment, with fields Art, Music, and Film. A user selects Music and MusicSubField appears. User selects Rock and submits the ticket. On the back end ArtSubField and FilmSubfield are NULL.
Essentially, I'd like to aggregate ticket counts based on subfield.
-
正式なコメント
Hey Jason,
Another suggestion is to use Groups to organize your subfields. You can read more in this recipe.
- Andrew
-
It's not pretty, but I've managed to handle this with nested IF's
IF ([Ticket Form] = " Form1") THEN [Form1 Component]
ELSEIF ([Ticket Form] = "Form2") THEN [Form2 Component]
ELSEIF ([Ticket Form] = "Form3") THEN [Form3 Component]
ELSEIF ([Ticket Form] = "Form4") THEN [Form4 Component]
ELSEIF ([Ticket Form] = "Form5") THEN [Form5 Component]
ENDIF
ENDIF
ENDIF
ENDIF
ENDIF -
This is a much cleaner option. Thanks!
-
Awesome! Glad we could help.
サインインしてコメントを残してください。
4 コメント