Hi everyone, I am trying to automate a process to scan a google sheet for certain info, then cross check it with a second sheet to get the missing values from there.
The issue I have is that the update record module always produces the result in on cell and it needs to actually fill out multiple different cells.
Any advice on how to go about this issue would be greatly appreciated!
Best Regards
Ilian
Welcome to the Make community!
Try mapping a “Row Number” from a previous module.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Hey Ilian,
you don’t need the Iterator modules after the Search modules, you are already getting one bundle per row, so the iterator is not doing anything.
The issue you have is that you mapped the iterator’s bundle order position to the row number value - so it will always be 1, 2, 3, 4 or 5 in your case. Like Sam said, you need to map the Row Number from the previous Search module.
