Hello friends, I hope you can help me with this issue that I have since I am new to appsheet.
I am designing an app as a test where I have in one part an inventory of products with a retail price and another with a wholesale price, so far the function of entering the data to be saved in the INVENTORY sheet works well.
Now in my SALES app I put a dropdown with the WHOLESALE and RETAIL values, what I want to do is that when selecting any of these 2 options, the PRICE field will place the price that corresponds to WHOLESALE or RETAIL from the INVENTORY sheet. How can I do this? I already have many days looking for information and many tests and I can not do it.
In other programming, I did it with IF comparisons.
Thank you very much and a big hug to all.
LinkedIn
Twitter
