So I’ve got a 2 Sheets. 1 has list of name and phone number, 2nd pulls the name from sheet 1 where the user can select the name and the phone number is automatically populated via vlookup. This is all in Google Sheets.
Issue #1: In Appsheets, that column with the names is listed as a Enum and for some reason it does not display all of the names? Do I need to use something other than Enum?
Issue #2: I also have imported a new Table (Sheet 2) where I can add new Names and Phone Numbers in Appsheets. Once I’ve added a new name and number, I expect that the new number is available for me to select in Appsheets, but it doesn’t show up. Do I need to refresh somewhere where the data in the Names and PHone Numbers sheet is seen by Appsheet.
If i save a new name and number in Appsheet, it definitley shows up in Google sheets on both Sheet 2 and Sheet 1. but for some reason the new name and number isn’t seen by Appsheets.
EDIT:
So it looks like if I Regenerate the Structure of my Columns table, all new data shows up, but I don’t want to have to log into my appsheets interface to do that every time I add a new name/number. Is it possible to regenerate the structure from the App sort of like refresh?
What are my options here?
EDIT2:
So i’ve figured it out. This video has the answer: https://www.youtube.com/watch?v=WA6Ku8ta2MU incase other people are having the same issue.