I have a trigger, when a new spreadsheet row is added. I take the row number (start at 2) because of the header. So the first value should be 2.
A format step will MINUS 1 from the Row number - giving me 1. This is the fist row after the column header.
But I need to format the number to 3 digits, like 001.
When it hits 10, it the value should be 010, then 100 and so on.
Any ideas? Thank you!
Best answer by ikbelkirasan
View original
+12
const rowNumber = String(+inputData.rowNumber).padStart(3, "0");
output = [{ rowNumber }];
const rowNumber = String(+inputData.rowNumber).padStart(3, "0");
output = [{ rowNumber }];
Thanks! However, I need the 1st row after the column header to be ROW 001. Can you code MINUS 1 or should I add a format step?
+12
const rowNumber = String(+inputData.rowNumber - 1).padStart(3, "0");
output = [{ rowNumber }];
Thanks for the solution again. I looked at adding data to Google Sheets and formatting the Row number into 3 digits, but your solution is much more streamline for Zapier. If you’re interested, you can find it here:
https://docs.google.com/spreadsheets/d/1oAtDLo2Bk-3SaUAYX9GrscC6DN_h8lO8pqLUWPTAoJw/edit?usp=sharing
A2 =ARRAYFORMULA(IF(B2:B="",,TEXT(ROW(data!A1:A), "000")))
B2 =ARRAYFORMULA(data!A2:B)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.