Pick row(s)
Let users of your app pick one or multiple rows from a worksheet
|
|||||
|
|
|
||||
|
|
||||
|
|
|
||||
|
|
|
||||
With this building block the user of the app can load a single or multiple rows from a worksheet.
When dragging this block into the flow you can either select an existing Google Sheet from Google Drive or you can create a new one. If you choose to select an existing sheet, a file picker dialog will help to locate the sheet on your Google Drive.
Creating a new spreadsheet will open the new sheet in a new browser tab.
If you do not create or select a Google Sheet by clicking on the Cancel button, you can load a row from a Google Sheet that may have been looked up in a previous step.
The building block shows all the columns found in the selected worksheet on the right-hand side. All of these variables will get a green sheet icon.
Use cases
- Let user pick data from a sheet and merge the selected data into your documents or emails
- Send out newsletters or documents for selected rows of a sheet
- Print business cards or address labels using data from Google Sheets
Configuration
Click on the bold text parts in the title of the building block to configure this block.
Click on one row or multiple rows to toggle whether the user can select just a single selected row or multiple rows.
If you are loading multiple rows your output variables will represent multiple values. You will notice that they get prefix and you will find three lines on the right of the variables.
As user interaction is enabled the flow will halt and let the user pick the row(s) to be loaded.
Click on the name of the selected Google Sheet to pick a different file from Google Drive.
If you have selected a Google Sheet you can pick the worksheet to be loaded by clicking on the bold worksheet name in the title of the building block.
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 edit the template in a new browser tab.
Useful combinations
Send emails to all recipients in a worksheet
|
|||||
|
|
||||
|
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|
||||
In this simple example shows how to send a personalized email to all users stored in a worksheet. The Ultradox file is executed in a batch job causing the Load row(s) building block to successively load all rows of the selected worksheet and perform the following building blocks.
For each loaded row the a personalized email is generated based on a template document you design. The HTML email is then sent to the email recipient derived from the worksheet.
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: 7/13/19