Bridge workflow - add multiple rows with one api call

I have an incoming sheet (sheet 1) that gets entries through a userform and it allows users to request up to 5 items per form submission. Each item goes into its own column (Column1 through Column5). Then I have a bridge workflow that is triggered when a new row is added to sheet 1. This workflow creates a new row for each item on sheet 2, then deletes the row that triggered the workflow from sheet 1, and finishes up with sorting sheet 2.

This works laid out as you can see below, but I'd like to consolidate and just do one addRow action.

I do have a column that shows the number of items that were entered, so I could use that for the number of iterations needed, or go until it finds a column with no entry, or it tops out at 5.

I'm thinking it might be something like…

If column1 <> "" Then create newRowArray1

If column2 <> "" Then create newRowArray2

If column3 <> "" Then create newRowArray3

If column4 <> "" Then create newRowArray4

If column5 <> "" Then create newRowArray5

AddRow on sheet 2 for all newRowArrays

Sort sheet 2

DeleteRow from sheet 1.

Not sure the best way to do all this… Maybe a child workflow to create each of the new row arrays? Is bulk addrows an api call?

Find more posts tagged with

Integrations

Accepted answers

Paul Newcome

What happens if you use this for the request body?

JohnRitchey

That worked… ty

All comments

Paul Newcome

My suggestion would be to use a JavaScript module to manipulate the data from the submitted row. You can have that output the request body for an API module to bulk add rows in a single call. That would reduce your workflow to five modules total.

Get Row (retrieve data)

JavaScript (manipulate data)

API Call (add bulk rows)

API Call (sort sheet)

Delete Row (remove original submission)

JohnRitchey

So here is my failed attempt at javascript module…

I put all my variables and columnIDs in the keys and values

and my javascript

And my error

Paul Newcome

Near the end of your script you have

Tag: varT[i]

But I don't see varT defined anywhere.

JohnRitchey

maybe i cant do it this way?

varCount has the number of columns that contain a value in T0 through T4 (5 total columns). I intended on using this to set my number of loop iterations. For each loop, it would create newRowArray(i) with varT(i). So for the first loop, i would = 0 meaning it would create newRowArray0 and use the value from varT0. For the second loop, it would create newRowArray1 and use the value from varT1 and so on.

JohnRitchey

I changed up my script a bit and this is my new error.

JohnRitchey

Have made progress in case anyone is following along or has an answer for the last part of this…

Here is the javascript that I was able to successfully create the new row arrays with and the run log.

My API call to sort the sheet has already been tested and works.

The last thing I'm not sure about is the bulk add rows API call. I will have between 1 and 5 of the newRowArray's each time.

— Do you create an array of arrays and just add that?

— To map put which column each variable should go to, would I enter each column ID as a key and the variable name as the value?

Paul Newcome

You need to have your JS output the combined array so that all you have to drop into the request body of the API call is the JS Module's output. The column ids and whatnot should already be in the output.

[{"cells": [ {"columnId": 7960873114331012, "value": true}, {"columnId": 642523719853956, "value": "New status", "strict": false} ] }, {"cells": [ {"columnId": 7960873114331012, "value": true}, {"columnId": 642523719853956, "value": "New status", "strict": false} ] }]

JohnRitchey

It sure is getting close…

With this javascript,

I'm getting it to create these arrays

Unfortunately, the rows it adds are blank

I tried removing adding just one column of data to each new row to pinpoint if it was just one particular column that was causing the issue, but got blank rows with just one column.

Paul Newcome

Make sure the sheet you are adding rows to is definitely the sheet you are looking at. Also scroll all the way down on the sheet to see if they are at the bottom of the sheet.

I tend to leave off the "toBottom" and "toTop" arguments. It defaults to "toBottom", and I generally end up sorting anyway at which point it really doesn't matter where the new row is added.

Can you provide a screenshot of the API results with the "rows" section expanded so we can see what it is saying it output?

JohnRitchey

Doesn't look good…

Paul Newcome

Ok. And what about a screenshot of the API module setup?

JohnRitchey

JohnRitchey

Paul Newcome

What happens if you use this for the request body?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.