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.