Retrieving values based upon responses

Hi @phil_pharos Thanks for stopping by the community! I hope you’re having a lovely week so far. 

To answer your questions, 

1. This is possible, but it is a bit of a setup. Essentially, you would need to create as many possible combinations of this as possible and then use this setup for logic jumps to show the corresponding one. 
2. It isn’t possible to obtain data from an outside source. All of the data needs to be set within the form. 
3. You can definitely adjust calculations based on selections. Our article here can help you get started using calculations. 

Hopefully this helps you get started! Let us know if you have any other questions. 

Hi Liz - appreciate the quick feedback. I thought it might be a lot of work to setup. We currently have a solution that is built in PHP/MySQL. I.E: web interface with a database at the backend. The solution is messy and we will replace it. What we do is buy used cell phones from the private market. So the customer enters the site, selects their phone using 3 dropdowns and which then pulls the base value for the cell phone. The customer/seller then answers a few basic questions which then may reduce the base value. Once completed, the customer then fills out a registration form. My ‘logic’ and thought behind this was that maybe Typeform could be a good backup replacement solution. As I am understanding it Typeform has no ability to query a database or Google Sheet and thus I would have to use Typeform logic jumps to do this.
I will take a look at your ‘this setup’. With 250+ cell phones it could be quite a bit of work.

Again, thanks for your feedback.

Regards

Phil

Oh gosh, yes, that would be quite a bit of work, @phil_pharos . @mathio or @picsoung might have a workaround for you using the APIs, but I’m not 100% sure on that. 

I think you might be able to achieve this by connecting 2 typeforms:

1. create 1st form
   1. customer will select product from a dropdown (you can copy-paste values from your spreadsheet)
   2. they will also select condition eg. from multiple choice question
   3. on submit they will be redirected to custom page
2. custom page
   1. it can receive responses from 1st form as query params in URL
   2. it will lookup the price in database
   3. it will redirect to 2nd form with price as hidden field as query param in URL
3. 2nd form
   1. it will display the price based on hidden field
   2. you can pass product details and condition as hidden fields too
   3. you can collect user details here

I hope this helps.

Hi Mathio - appreciate the response and idea. I am going to start on this project, hopefully early next week. I will only set up a few products/mobiles to start up with. In terms of setting up the custom page, is there any documentation available that can assist here?

Regards

Phil

From our side, you can see this help article on redirect with variables:
https://www.typeform.com/help/a/use-variables-in-redirect-links-4414707303700/

In case you are using Google Sheets, you can use https://sheetdb.io/ to retrieve data from your spreadsheet, They provide a simple service that might fit your needs. If you are looking for code examples, I have recently implemented their API in JavaScript in an unrelated case, but you can reuse most of my code - see the example here.

I built an example of a similar use case here: 

https://mathio.github.io/typeform-embed/html/retrieve-from-google-sheet.html

Feel free to reuse whatever you can, if it helps.

very cool @mathio