Let me explain from somewhere near the beginning:
I would like customers to be able to fill out a form on our website (or somehow linked to it) and this data then be used to automatically generate a task and subtasks based on the data supplied in the form.
At the moment we have a form that generates a PDF which is then emailed to our business.
Initially, I thought Asana Forms would be the way to go, but one of the data fields in the form is a multi-choice field, with more than 50 options. Asana Forms does not allow for multi-choice questions with more than 50 options.
After some thought, I came up with another potential solution. Say the form on our website generates a spreadsheet with the data, instead of a pdf. Is there some way Asana could automatically read that spreadsheet, and create a task and subtasks based on the data within the CSV file? I know there’s some way through Zapier to integrate a spreadsheet with Asana, but can this read directly from the spreadsheet and populate things in Asana tasks, or does it only trigger template actions within Asana?
Sorry if this is a head-scratcher, but this would be a real time saver for us.