Update row
Update rows of an existing worksheet
|
|||||
|
|
|
||||
|
|
||||
|
|
||||
Use cases
- Tracking subscription state (Example Newsletter)
- Updating form responses
- Update data in a customer sheet
Configuration
Click on the bold text in the title of the building block to open the configuration dialog.
Reload
Click on the reload icon to scan the template again to track down added or removed variables. If you have renamed your template on Google Drive clicking on this button will also update the document name in Ultradox.
Edit
Use the edit icon to open and edit the Google Sheet in a new browser tab.
Usage
When dragging this block into the flow you can either select an existing spreadsheet from Google Drive or you can create a new one. If you choose to select an existing sheet, a file picker dialog will help you to find the sheet on your Google Drive. Creating a new spreadsheet will open the new sheet in a new browser tab.
After selecting the Google Sheet a dialog pops up that allows you to select the columns to be updated and to specify the values for each column.
You can update cells of an existing row with a simple fixed strings or with the content of a variable.
As in most of the text boxes in Ultradox you can leverage the full feature set of Ultradox templating. This makes it easy to format dates, numbers, currencies etc. according to your needs.
As you are updating an existing row you will have to specify the row number to be updated. This can either be done by entering a number or by entering a variable that contains the row number to be updated.
Updating multiple rows at once
You can even update multiple rows at once if you separate the row numbers by comma.
You can for example enter 2,5,8 to update the second, fifth and eighth row at once.
If you have loaded rows using the Load worksheet building block you will find all loaded row numbers in a variable called rows[].rowNumber
To update all of the loaded rows just create a forearch statement to print all row numbers separated by comma:
${foreach rows row ,}${row.rowNumber}${end}
Useful combinations
Update delivery status of an email campaign
|
|||||
|
|
||||
|
|
|
||||
|
|||||
|
|
||||
|
|
|
||||
|
|
|
||||
|
|||||
|
|
||||
|
|||
|
|||||
|
|
||||
|
|
||||
|
|||
|
|||||
|
|
||||
|
|
||||
In this example an newsletter is send to all contacts listed in a Subscribers sheet. The flow is executed in batch, so all building blocks are executed for each row of the Subscribers sheet.
After the newsletter is sent to a subscriber its corresponding row in the subscriber sheet is updates. First the status is set to "open". The execution is stopped after the email was sent and the status got updated.
When sending emails via Amazon Web Services you can automatically receive an email status. So in the tracking settings of the Plain text email building block you can enter a URL that is called in case the email is delivered or bounced. Here you can enter the URL of an Update row building block.
In case for example the email bounces, AWS calls the bounce URL which represents the update row building block to set the status to "bounced". As of the batch execution each picked row is unique, so calling the bounce URL will automatically update the row that represents the subscriber who was supposed to receive the bounced email.
You can maintain tracking URLs for "open", "delivered", "bounced", and "complain" allowing you to keep detailed track of you email campaign.
Learn more
You can also use Send personalized Emails wizard with tracking activated.
Questions and Feedback
If you have any comments on this page, feel free to add suggestions right to the Google document that we are using to create this site.
If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.
Last Updated: 1/6/18