I’m quick new in Appsheet: which is just amazing!
I’ve started to create my first app based on gsheet and I’m struggling to achieve 1 form:
The purpose of the form is to update my inventory:
I’ve basically 3 fields in my INVENTORY table
SKU is my unique identifier and the form should work as described:
I scan SKU
I scan Location
It creates a new record in the inventory table.
up to this point it works.
What i would like to do now is :
If SKU exist, get a warning and get a capability to update the existing records ( for the given SKU, update location and timestamp)
Up to this point, I’ve been able to create a virtual column telling me where the existing SKU is store but i can’t make the final step which is to update the existing record in the inventory table ( or alternatively, delete the existing record and add the new one)
I hope someone could help