How to provide instant quotes

Support
1

Hello! I have a simple price sheet for my tshirt shop store in a google spreadsheet. I would like to be able to provide an instant quote at the end of the form based on the quantity of shirts someone inputs. How would I do this. Thanks in advance!

1 Like
2

Hello there! You can refer to this link on how to integrate google sheets to your form: Google Sheets Integration | Feathery
You can do that to send data to your sheet and then utilize an API call again to get your result (sample use of API call to google sheet: Pre-fill field options from Google Sheets | Feathery Docs )

3

Hello there :slightly_smiling_face:

Use the steps below to get a quick cost based on the number of shirts in your Google Spreadsheet:

  • Set up columns for number and unit pricing on your price sheet.
  • Use a formula to determine the total cost in a new column.
  • Have a form with a link to the excel file so that clients may enter the amount.
  • Make sure the excel file receives the form replies; and that the formula uses the input to determine the final price automatically.
  • Instant quotes will be available with this arrangement as responses are sent in.