Configuring my Invoice and having issues with lookup table. Each question in my form is for an individual item. I have 11 items with different prices

Attempting to create a lookup table for the pricing when someone submits an order. For each question I have a different item and each item has a different price. I want to be able to calculate the price per item, especially when more than 1 quantity selected, and find the total of the invoice. I keep getting a failed status. What am I doing wrong?

Hi @Srgirard999,

It looks like you haven't set up the Lookup Table correctly. Please note that the Lookup Table checks for the value received in the Lookup Key, not the label. For example, in your Lookup Table, it is looking for “1,” and since there is no label set as “1,” it is returning a failed result.

Now, coming to your main issue: the use case you are trying to achieve is not possible using a Lookup Table. You would need to add a Code step to your workflow that can act as a database and calculate the invoice price.

If you could share your Google Form, we can add the code on your behalf.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
? Pabbly.com