I suggest you ...

Use calculated fields in file name and email.

We would like to use the job number in our file name, however, the job number is created based on answers in the form... it is not something someone creates themselves. This feature would allow us to add a column in the response sheet that has a formula calculating the job number for each entry. Then, we could use the result in this column as a marker just like any other.

For instance, we would use it to combine the date of the job form answer (Jan 1, 2018) with the Account Manager answer (John Smith). The result is a unique job number that we format like this (010118JS). Then we could use the marker <<Job Number>> in the filename or in the automated emails, etc.

3 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Peter Fontana shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feature requests

Feedback and Knowledge Base