I want to make an app where values are uploaded to a production table, but I want this data to also be removed from the table once it is used in another part of the production, I would do this through a QR, that when the value is recorded in another table it disappears or at least it appears to me that it is no longer in the original production and was used.
Is there any way to interlace the 2 sheets in app sheets?
You can use as many spreadsheets as one AppSheet app’s data sources and what you want is not difficult by using a bot or a Form save action.