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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Peter Fontana shared this idea  ·   ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base