Editing data in multiple data sources from a single form?

AppSheet AppSheet Q&A
1

Hi! I am pretty new to appsheet and no expert in development, so I would appreciate any input or guidance!

I am building an app for inventory management, and have a solid master list and a single location, but I am trying to build in functionality for managing inventory across many locations working off the same master inventory list but needing to track their own unique stock amounts.

Location A inventory is in the same sheet as the master list, so editing the master list is simple. For Location B, I have made a separate sheet that references the main data in the master list.

This makes it so you cannot edit any master data from Location B.

I tried to use LINKTOFORM to link to the form that edits the master list, but it requires at least one row to be filled out, and for a new item to be added to inventory there is nothing that can be filled out. Additionally, I would prefer for the unique location data (amount in stock, etc) to be filled in alongside the master list data (name of item, image, category, etc.)

Is there a way to create a form view that adds or edits data in multiple sources from the same action?

2

Consider creating a separate table simply for input. The form view allows the user to enter a location in addition to the product and count. When the form is saved, a Form Saved event action or a bot uses the form data to update the appropriate table.

3

I think that would solve my problem, thank you!

Through that solution, would I also be able to add in an “approval” step, where an admin reviews the edit before it is posted to the main data?

4

Absolutely! When the user submits the form, the bot could notify the reviewer. Then the reviewer could approve or deny. The bot could then apply the changes if approved, or notify the original user if denied.