The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Sep 19, 2020 09:46 AM
I would like users to be able to select an individual name when filling a form.
I created a calculated field with the Last and First Names.
But it seems I cannot add a calculated field to a form.
How else can I do this?
Just to clarify. If I have calculated two entries “Smith, John” and “Smith, Peter” how can I list them in the form?
Solved! Go to Solution.
Sep 22, 2020 12:14 AM
Sep 21, 2020 01:53 PM
Hi @Rafael_Calvo - not sure what your base setup is, but from the description, I’m guessing the user will choose a person and add some additional information about this person - is that right? From what you say, the people are pre-defined and come from first and last name fields. To achieve this I would have two tables - one for the people:
and one for the form data:
In the form table “person” is a linked field.
Then in your form you can do exactly as you describe:
Sep 22, 2020 12:14 AM
Thanks Jonathan. Yes, I solved it in a similar way but using 1 Table