Solved: Autofill between tables - Page 2

MarcG · 03-07-2021 08:12 AM

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.

MarcG

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**

View solution in original post