Is there a function similar to COALESCE?

回答済み

2018年11月09日 20:05

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.

4 コメント

正式なコメント
Andrew Forbes
- 2018年11月12日 18:56
Hey Jason,

Another suggestion is to use Groups to organize your subfields. You can read more in this recipe.

- Andrew
Jason McCann
- 2018年11月12日 15:43
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

0
Jason McCann
- 2018年11月12日 19:30
This is a much cleaner option. Thanks!

0
Andrew Forbes
- 2018年11月12日 21:02
Awesome! Glad we could help.

0

サインインしてコメントを残してください。

4 コメント

お探しのものを見つけられませんでしたか？