Hi guys, back again with a simple sounding problem that is flummoxing me.
Background
I have two distinct Google sheets (not tabs) that require to be linked in this app and writeback be performed on both according to input in the app.
Sheet 1: Customer details and orders belonging to Department 1 e.g. John Smith's details and his order for product 1
Sheet 2: Product details belonging to Department 2 e.g. product 1 and its associated properities.
The app is being designed to use Sheet 1 as the primary data driver. For example, if John Smith orders product 1 the app user will mark when it is delivered through the app which will write to Sheet 1. This action needs to then write to Sheet 2 to changed product 1 to delivered.
Both datasets have come under my purview now where they have previously been owned by two separate departments before anyone asks why this wasn't designed as an integrated sheet...
Problem 1
When selecting John Smith's record in Sheet 1 the option for products requires to come from a column in Sheet 2. Products have a unique 3 digit number. I cannot figure out how to make the column go "Right, the values required to populate this dropdown come from Column X in Sheet 2".
If i try using LIST its gives me a long comma-separated list of all the values which is not helpful. I require individual values to be selectable. Any tips?
Problem 2
Sheet 2 requires to be updated from the outcome of user choices in the app. For example, the default values for the stock column in Sheet 2 is 'At Warehouse' which indicating the product is available. If the user selects the unique product in the app and also changes the app record to 'delivered' we require this to write back to Sheet 2 so that the unique product is marked as 'delivered' and is no longer available in inventory.
How do i get my app to write back to Sheet 2 on the basis of values now written into Sheet 1?
LinkedIn
Twitter
