This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.
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.
Best bet is just to set the column type to text and in the valid if put Table Name[name Column]
Appsheet should intelligently recognize this and create a drop down list.
I tried your suggestion but it did not seem to work. I do not understand what I am doing wrong. I have the table inported and the name is Sheet1. I put Sheet1[Name] in my other table for the HR report in the valid if entry under Name. It does not even show the field in the app.
Yes, sometimes it will show and sometimes it wonโt. But it wonโt show a dropdown list populated with the names in the Names column when it does show. It will be just a blank box to type in. If I put the โValid ifโ field populated with Sheet1[Name] then the field disappears.
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.
When the app itself adds rows, it will populate the key column with a unique identifier, but itโs up to you to tell AppSheet how to generate the identifier.
LinkedIn
Twitter
