Difference between ${currentRow} rowId and rowNumber please HELP

[Jean RUCH]

Hi All,

Im' getting mad, let me try to explain

1) I use a Google form to collect data 

2) These datas are collected in a spreadsheet

3) in this spreadsheet there is a formula to calculate taxes with a formula like this

=ARRAYFORMULA(IF(ROW(A:A)=1; "frais"; IF(LEN(A:A)>0; Q:Q*0,03;)))

That's working fine

Now my issue:

Every time there is a google form submission, my ULTRADOX workflow do that

1. Load 1 row (exactly the last that was created) from the worksheet (to have taxes calculated)
   
2. Generate a PDF document
   
3. Upload this file to a Google drive folder
   
4. Update a cell with the link to the google PDF file created
   
5. and SEND A PLAIN TEXT with the pdf attached
   

It worked a few days ago, but now i don't remember how to select the correct row from the sheet (not the row number 2 but the last that was submitted)

What are the differences between rowId, currentRow and rowNumber ?

Is my workflow correct ? Can you help me ?

Jean from France

[Daniel Florey]

Can you try to remove all empty rows in the spreadsheet with arrayformula and check if this helps?

This is a known Google issue.

--
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 https://groups.google.com/group/floreysoft.
For more options, visit https://groups.google.com/d/optout.

[Jean RUCH]

Hi Daniel

There is no blank rows (8 rows with the first one with the ARRAY)

Jean RUCH

06.62.58.15.90

--
You received this message because you are subscribed to a topic in the Google Groups "floreysoft" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/floreysoft/ZtNNpzr5vRM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to floreysoft+...@googlegroups.com.

[Daniel Florey]

Hi,

can you please download and start the remote support tool and send me the session code when you are online?

http://get.teamviewer.com/floreysoft

I'll then have a look and will try to help you.

Thanks,

Daniel

[Jean RUCH]

s03-658-887

Jean RUCH

06.62.58.15.90

[Jean RUCH]

Thank you so much Daniel

Great product but difficult for newbies like me.

Sorry for the end of the work: i had 2 sons and my wife had a car crash twenty years ago: sometimes i have to interrupt my job, to care about, that's why I leave you a few minutes like an idiot.

Jean

Jean RUCH

06.62.58.15.90

[Daniel Florey]

No problem, hope all is running well now  ;-)

[Jean RUCH]

Working great !!!

Jean RUCH

06.62.58.15.90

[Adam Saunier]

Do you Mind posting what the solution was and if possible a screenshot of what your ultradox console looks like? I am having a very similar problem to what you were having.