Deep Links - linktorow() I have created an a...

(JMI Labs) #1

Deep Links - linktorow()

I have created an action that is the “Execute a group of actions.”

In general terms, I want the action to change a separate field to Y (the row contains the time a user is selecting for a meeting), and then transition to a form view with that selected time now included.

Here’s what I’ve tried, and I’m not sure why it isn’t working.

Action 1 - Set the value of [select] to Y.

No problems, works fine.

Workflow rule fires on action 1 that runs google script in the sheet to write that time to a row in another sheet (called New Event) where the user has already input a few details about what they are scheduling.

The New Event sheet only has 1 row (macro cleans it up after it runs), with a static key that I have used in the next action step.

Action 2

  • A go to view action using linktorow(“Key”, “Form View”).

While the app is moving to that view, the macro writes the time to the New Event sheet like it should, but the chosen time is not showing up in my form view when the sync completes.

Does the linktorow() view generate before the sync occurs and doesn’t fetch the latest data?

Anyone have a solution?

Am I missing something?

(Aleksi Alkio) #2

Yes it’s a timing issue. Your app is not waiting for your script.

(JMI Labs) #3

does linktorow allow you to pre-populate form values like linktoform?

(Aleksi Alkio) #4

No, that’s why we have the LINKTOFORM.