This is a scenario I am testing, the first row merges content from one spreadsheet to the next
Here’s the output:
When I go to and run the second row, it keeps adding extra rows???
Essentially, the first row is merging a custom spreadsheet data to a square space product sheet, as the client has a specific format they want for the title.
The second row is then adding the output to a master square space sheet.
Your question is unclear.
“Watch new rows” does this:
For each new row in the first spreadsheet
“Add a Row” does this:
Add a row to the second spreadsheet
Combined, it does:
For each new row in the first spreadsheet, Add a row to the second spreadsheet
So the modules are working as intended.
If this is not what you are expecting, please provide an example of how you want it to look like.
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 there,
So the first spreadsheet is the clients custom one:
I then have to combine D, B, E as the title for the product listing, I also have round up the prices as well, which I’ve done using the if() function.
I then want to pass this data into an official square space imported CSV file:
But it comes through duplicated, or 3 entries. This is where I am going wrong?
I want to then allow the client to view this sheet prior to importing into their current square space imported CSV file.
If you need further assistance, please provide the following:
Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:
Method 1: Type code block manually
Add three backticks ``` before and after the content/bundle, like this:
```
content goes here
```
Method 2. Highlight and click the format button in the editor
Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.
By providing these details, it will allow others to assist you better.
Hey there,
Sorry forgot to add that:
blueprint (1).json (80.8 KB)
