I have recently started to build an app for my company with AppSheet and have stumbled into a problem I cannot seem to find the right answer for.
So I have the following Tables drawn from Tabs in Google Sheets;
For “Companies”, “Contacts” & “Assets” I have successfully created forms however for “Tickets” I wish for the following fields;
Company - Draws Company Names from Companies Table
Asset - I can draw all assets from my assets table however I want to only show assets related to the company selected from the dropdown above that is referencing the companies table.
So to confirm I need to only show assets that have the unique identifier of the company opposed to showing all assets in the system?
Can anyone help?