Can I use two field contents as choices?
I have a Couples table with fields 'name 1' and 'name 2' (with entries say "John" and "Sally").
Can i have a 'who attended' choice field, where "John" and "Sally" are the options?
(i thought dymanic choice fields might work but they only show the data from one field)
Thanks!
James
6 replies
-
With a dynamic multiple choice field?
-
Thank,s but - dynamic multiple choice & dynamic choice fields only show the contents of one field across a selectiom of records.
I have couple records with two names on them. I want to show that one or both partners attended. So I'd like a choice field where there are three choices: 'name 1', 'name 2' and 'Both'.
I was hoping there was a way i could have a dymamic choice field showing the contents of two fields on on one record. For example, if 'name 1' is "John" and 'name 2' is 'Sally" on the one couple record, the dynamic choice field 'Who attended' would offer "John", "Sally" and "Both".
-
Strange, I tested it and this is what I get if I use a dynamic MULTIPLE choice field:
Steven
-
hi Steven - think i was unclear.
I have fields 'Name 1' and 'Name 2'.
Can i have a choice field where options are 'Name 1', and 'Name 2'?
So, if 'Name 1' is "Bob" and 'Name 2' is "Sally", can i have a choice field with options 1" "Bob and option 2 "Sally"?
Thanks for all your help.
-
Dynamic choice fields are based on records in a table not on fields.
-
Well yes, if you're willing to use a trick, you have to have an extra table with all the possible names that could appear in your (Multiple) choice fields.
Steven.
Content aside
- 3 yrs agoLast active
- 6Replies
- 442Views