Solved: How to reference a column from another table - Page 2

Eric_Bourne · 02-05-2020 02:22 PM

I have a “staff directory” app and am making a HR report app and I want the name column to be a dropdown list that references the names in the “staff directory” list and can choose each one from a drop down. I have added the table to the app and I reference it but am not sure how to select the names column to populate that choices.

Eric_Bourne

I figured out my issue. I created an ID field in the A column but did not manually input anything into them. So without the ID “Key” field, it wasn’t pulling any records. Is there a way to have the system automatically assign ID fields to each row? Does it do this automatically when a new record is created by the app? I set up the sheet before hand in google sheets and then imported it to set it up.

View solution in original post