Help Needed: Auto Update Multiple Choice List

Hi @@malahideastro Welcome to the community! This sounds like quite a nice nonprofit. 😀

I’m afraid we don’t have a solution to automatically update the answer options or form. You could try doing this using the API - perhaps @picsoung or @mathio know of some workarounds!

Thanks @Liz ​​​​​

It really would be fantastic to ​​​​get the community support with this. @picsoung @mathio @john.desborough 

Hello @@malahideastro 

We do not support dynamic values for multiple choice. You will need to write a custom script to update your typeform via API every time there is any change to the spreadsheet. 

Thanks @mathio

I wouldn’t been technically advanced to write scripts unfortunately.

How would I go about getting an expert to support me with Typeform integration. This would be just one possible support we could need. 

@@malahideastro - the APIs would be the most elegant solution but you could do something with Google Sheets and an add-on called Document Studio … something along these lines

use google sheets/document studio to send out a link to the confirm/pay form that has the name, email and game date passed as hidden variables. (need to create those hidden fields in the game day form) - this way, all you would have to do is go into the google sheet and run the Document studio workflow (about 20 seconds of time) to send out the ‘game day - time to confirm’ email that has a link to the form and allows the user to answer a simple question “you playing tonight?” if yes go to the payment page. if no, send them to an ending that says thanks and see ya next time

• connect your original typeform to a google sheet (if you haven’t yet, that will reduce the manual export process)
• since you have their email in the spreadsheet, you can add a tab to allow you to enter in the date of the game day and use the arrayformula() function to pull the date into a column on ‘reporting’ tab 
  • i always suggest creating a second  tab for ‘reporting’ in these case so that you could bring the details you need from the tab that typeform uses to dump the data - bring in the name, email data from the main tab to the dump tab using the arrayfomula() function - that will bring every new registration across 
• in the google sheet, on the reporting tab, use one column to pull the details into a url in the field - the link to the form that includes the hidden variables that you want to pass to the confirm/payment form
• create the document studio workflow that will pull the details into the email (including the url with the hidden fields) and send it when you run it
• in the confirm/pay form, your “are you playing tonight?” question can show the user their name using the @recall feature and show the game date .. and use the yes no logic
  • if they say yes go to payment page. 

i know that’s a bit of work to get set up but it literally means that all you would have to do on game day is put in the date in the one field and run the work flow and all the registered folks get the email to the confirm and pay form

i would suggest you add a second link in the email you send out that allows people to ‘leave the list for good’ .. ie an unsubscribe type option. and send the same name and email fields across as hidden fields

• you create a small form that displays their name and email on a yes no question and says “are you sure that you want to leave the league?” - if no then send them to an appropriate ending
  • if yes, you have a couple of options - you can connect this form to the same google sheet and collect the unsubs on that tab 
  • you can then manually  delete the folks from the list or set up a macro-ish process that either deletes the user from the mail list or have an ‘unsubscribed’ column where you put ‘yes’ flag 
    • your document studio workflow would have to incorporate a filter that would NOT send the email to anyone with unsubscribed = yes. 

just some alternatives to using the APIs

des