I am attempting to select a price based on two different fields.
Example: Customer is selected but there are three different prices based on the work done.
Like the spreadsheat below is there a way to select Customer B and Service 2 to get $70?
0
Comments
Please sign in to leave a comment.
Hey Kenneth,
Yes that is possible! It's a slightly different way of looking at it but I have included the updates in a spreadsheet snapshot below:
This is called Dependent Reference Data, which you can learn more about at the linked Help Center article. Essentially, you are using reference data to create conditions where you choose the customer from a drop down menu, which then reduces the next drop down menu to only the services that are in a row with that customer chosen. Then the price will pre-populate based on the service. You would map the first two columns as you usually would, with the customer being the parent field and the service referencing the customer field. Then the price would reference the service field. I hope this helps but let us know if you have any other questions!
Thanks for the reply. I will have to change my app layout to accommodate this way but it will work.