Help with 2 tables to sync data

[Jose_Antonio_Te]

Hello there,
My first post here
I am developing an app concernig covid-19 for my work. The app has 1 table with 2 sheets
sheet1=patients status concernig covid-19, with patients id, name, symptoms, etc and the doctors name (this data sheet is delivered to google sheets every day without the DOCTORS NAME
sheet2= patients file, patients Id, name and DOCTORS NAME (this sheet has all the data from patients)
What I need is to append the DOCTORS NAME to the corresponding patient in sheet1 automatically by cross referencing patientId. Is this possible?
Can someone please help me?
Thanks

[shaaland]

Hi @Jose_Antonio_Teixeir,

Welcome to the AppSheet Community. @Steve posted an answer to a similar request on community in this thread: Copy data - i need just two values - and place in another table - not a new row?

How important is it to update the Sheet, vs. just being able to look up the information in the App you are building? If you can just point everyone that needs this information to the App, then a simple Reference from the First sheet to the second sheet using the Patient id would allow you to easily display all of the columns from both sheets in the app view. Make the Patient ID field a “Ref” type, and then click on the icon on the very left of the column name in the Table configuration screen in the Columns tab to set up the Reference to the second table.

If you need to copy the Doctor name to the first sheet, then you can try Steve’s suggested solution.

R,
Scott