Autofill between tables

[MarcG]

Hi, I’m new to Appsheet.

I have 4 tables; Basic Info, Appearance, Bio, Miscellaneous.
Each table has the columns “First_Name” and “Last_Name”.
The objective is when you enter data in the Basic Info “First_Name” column, that data would populate the relevant columns in the other 3 tables.

I used the app formula: TEXT(Basic Info[Last_Name]), which worked to a point. The issue is that whenever a new entry is created in Basic Info, all previous data is added with no option to select the relevant one.

[Marc_Dillon]

MarcG:

The objective is when you enter data in the Basic Info “First_Name” column, that data would populate the relevant columns in the other 3 tables.

I used the app formula: TEXT(Basic Info[Last_Name]), which worked to a point. The issue is that whenever a new entry is created in Basic Info, all previous data is added with no option to select the relevant one.

Expression of the form table[column] return a List type that is a comma-separated string of all values in that column, from all records in the table.

How do you intend to select which record in the first table to pull the names from?

[MarcG]

I don’t know tbh. Any suggestions would be appreciated.

[MarcG · Accepted solution]

SOLUTION - I created a column in the other tables (Appearance, Bio, Skills) called “Full Name”. Turned that into a REF type column. Then used the “Basic Info” table as the source. NB - It pulls the full name “First” and “Last”. This does create a dropdown list that allows the user to choose which name.
Using the above returns all the names created in Basic Info as a list with each name separated by comma.
So I used CONCATENATE([Character_Name]) for the _ComputedName AND _ComputedKey columns**