Selecting price from two parameters.

Comments

2 comments

  • Avatar
    GoCanvas Community Manager

    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!

    0
    Comment actions Permalink
  • Avatar
    Kenneth Teseniar

    Thanks for the reply.  I will have to change my app  layout to accommodate this way but it will work.

    0
    Comment actions Permalink

Please sign in to leave a comment.