Hello fellow Zappers - is this possible to achieve using Zapier? Thanks in advance!
- Upon an Asana project form submission – a task will be created in that project.
- The form has a field called Job Number for example a job number will look like this: 332040046
- Zapier will use this Job Number= 332040046 to find a match in google sheets.
- For example, if the user submits 332040046 on the Asana form in the Job Number field, Zapier should look in the google sheets (Column C=Job Number) for a match and retrieve whatever the corresponding value is in the Community_Key column for the Job Number= 332040046