Using advanced formulas in your Google Sheets template

Follow

Comments

11 comments

  • Avatar
    SensorsONE

    You mention to add a new sheet to the responses spreadsheet for the calculations, but shouldn't it be the invoice template where you add the calculations?

  • Avatar
    Form Publisher Team (Edited )

    Hi SensorsONE,

    You can either do your calculations on a separate sheet as explained from points 1 to 3, or calculate directly on the invoice template (see point 4.). Both will work! We have added this information on the article, thanks for your comment.

  • Avatar
    Randy Baril

    Is there a way to perform simple date calculations in a Google Doc?

  • Avatar
    Form Publisher Team

    Hi Randy Baril,

    Unfortunately, we did not find anyway to perform calculations in a Google Doc yet. We will continue to look for a solution and we'll keep you updated. 

    In the meantime let us know if you manage to pull this up!

  • Avatar
    Seiji Ohara

    Is there a way to have the calculations done outside Google Docs and then send the results back to Form-Publisher through some web response before the PDF is created?

    What we are trying to to do programmatically: automate formula creation, vlookup contents, personalized messages/results/conclusions for aggregated/anonymous data.

  • Avatar
    Form Publisher Team

    Hi,

    There is no way to get out of the Google Drive environment so (slide/sheet/doc) bfore the pdf creation, and the only type of file that allows formulas is Google Spreadsheet.

  • Avatar
    Mr Nigel S Haslam

    I need to combine Form Publisher's advanced formulas on a second sheet with Yet Another Mail Merge's ability to send an HTML email from my Google drafts folder.

    I can pull question data into the email template using the <<Markers>> but how to I access the VALUE data in a formula populated cell in my second 'operations' sheet, as shown in the Hotel Reservation tutorial?
    Thanks in advance

     

  • Avatar
    Form Publisher Team

    Hi,

    You can only pull this data in another sheet of your template, not elsewhere.

  • Avatar
    Christophe Gwynne

    I've been using Form Publisher successfully for a year now to generate new purchase order spreadsheets and pdf copies as well as emailing them to the relevant people. However I can not figure out how to simultaneously output the data to a running spreadsheet of all purchase orders. So I've been manually entering the relevant data into my running log spreadsheet after each new PO spreadsheet is created. How to automate that?

  • Avatar
    Ian Mullen

    Will the calculated result also populate in the form on screen so the user can see the result of any calculations before they hit submit which raises the relevant off etc.?

  • Avatar
    Form Publisher Team

    Hi,

    No those calculated result are done on the server side once the user submit is data.

Please sign in to leave a comment.

Powered by Zendesk