HI! i have to make an import of products and prices.
The issue is that the man who uploads does not know the codes:
idprod1
banana
15 usd
is it possible that he uploads
Banana 15 USD
or necesary it should be
idprod1 15 USD
(This is an easy example fot my issue)
Thanks
0 Likes
How is he uploading the data? Through an AppSheet form? CSV? Google Sheet?
You can allow the user to use the label of the product in lieu of the key, but you will just need to make sure you set you app up to allow this.
CSV!
Can you set up the csv to use a formula to lookup the idprod based on the name the the man chooses?