I’m relatively new to Appsheet, and have only built one app. A new training app I’m working on needs to have a table that references data in other tables based on various ID numbers. For instance, a trainee may have an employee ID which should link to a table with HR info, a training ID issued by an outside training vendor that links to a table with their classes from that vendor. How can I allow a user to just enter these IDs as text or a number without them picking the number from a list of possible values as a ref normally does? I ask because usually the ID gets assigned before that data is present in the other table, and nobody wants to have to “remember” the ID for a week until the info populates. They want to put the ID in when it’s assigned and forget about it, and the ref become “active” once the data is populated in the other sheet(s). Is this possible?
LinkedIn
Twitter
