Using Google Sheet formulas with Ultradox variables

[Harkirat Singh]

I am basically trying to create a dashboard of all the entries created using a particular form. The main reason behind this is that I want to capture the ${editResponseUrl} variable in a dashboard so that it can be easily used to update existing entries.

The steps I am trying to follow are:

1. Trigger using the intended Google Form

2. Insert a row into a new spreadsheet

4. Add the following Google Sheets formula to the Batch Settings of the Insert Rows Building Block

       =HYPERLINK("${editResponseUrl}","Update Details")

THIS DOESN'T WORK!!!

BUT THIS DOES

https://drive.google.com/drive/folders/${folderId}

[Daniel Florey]

You'll have to stick with Ultradox syntax. You cannot simply use statements used in other apps and expect them to work in Ultradox.

You should be able to insert the URL by simply using ${editResponseUrl}

[Harkirat Singh]

Thanks Daniel,

I was able to achieve the desired output using the following Formula in a hidden second row

=ARRAYFORMULA(if(E2:E="", ,HYPERLINK(E2:E,"Update")))

[Daniel Florey]

Great! Thanks for the tip!

--
You received this message because you are subscribed to the Google Groups "floreysoft" group.
To unsubscribe from this group and stop receiving emails from it, send an email to floreysoft+...@googlegroups.com.
To post to this group, send email to flore...@googlegroups.com.
Visit this group at http://groups.google.com/group/floreysoft.
For more options, visit https://groups.google.com/d/optout.