Help

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.

Calculated Last, First name selection in form

Topic Labels: Formulas
Solved
Jump to Solution
1592 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Rafael_Calvo
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions

Thanks Jonathan. Yes, I solved it in a similar way but using 1 Table

See Solution in Thread

2 Replies 2

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:

Screenshot 2020-09-21 at 21.51.28

and one for the form data:

Screenshot 2020-09-21 at 21.52.00

In the form table “person” is a linked field.

Then in your form you can do exactly as you describe:

Screenshot 2020-09-21 at 21.52.52

Screenshot 2020-09-21 at 21.52.58

Screenshot 2020-09-21 at 21.53.07

Thanks Jonathan. Yes, I solved it in a similar way but using 1 Table