Calculated Last, First name selection in form

Topic Labels: Formulas
Jump to Solution
1117 2
Showing results for 
Search instead for 
Did you mean: 
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