User fills in field that he forgot to fill

1204 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Here is the situation. We have a table (1) with 3 fields.
Field 1 - Name: Formula({First Name} & " " & {Last Name})
2 - First Name: Using a form, the person input his/her first name
3 - Last Name: Using a form, the person input his/her last name

Lets say i send this form to a few people and i receive a dozen of entries.

Now i add a 4th field:

4 - Favorite Color: Using a form, the person input their favorite color

Now i send it to a dozen users that fill it with their favorite color, but the previous users havent filled it.

Now, I create a new table (2), with two fields:
1 - User (linking to User in Table 1)
2 - Missing Color

The user can fill this new form and fill the missing color.

In table 1 i can know retrieve the missing color, but i get two fields containing colors. (Favorite Color and Missing Color)

I could hide those two fields, and create a new field that contains an IF condition that checks whether the Favorite Color or the Missing Color field is set, and then display the color.

But isn’t there a cleaner method?
If not is there a feature to be develop by Airtable devs?

thank you

1 Reply 1
8 - Airtable Astronomer
8 - Airtable Astronomer

I would have suggested a combination of using a rollup field on the ‘extra’ color, combined with a concatenate, of the 2 color fields.

However it doesn’t look like there is a persistent unique link for each user to their results like in google forms. There is other interest in a feature like what you need, where the end user could edit their response if the form changes after the fact.