Hello,


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