Load cells
Access data from certain cells
|
|||||
|
|
|
||||
|
|
||||
|
|
|
||||
Use cases
- Load configuration from sheet (Example App: Invoice from timesheet)
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 edit the template 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 will allows you to configure exactly which cells to load. In the dialog you can select the worksheet from your Google Sheet to be loaded. If you want to load cells from multiple worksheets, simply add more building blocks of this kind and select the different worksheets.
The building block shows all the data found in the Google Sheet on the right-hand side. All of these variables will get a green sheet icon. You can find all columns of all worksheets as variables. The three lines on the right of the variable indicate that each variable represents a list of values: they contain the data from all rows for each column.
You can specify the cells to be loaded by delimiting the enumerated cells by , . If you for example want to load the cells A3, B4 and D4 enter them without spaces and separated by comma like this: A3,B4,D4.
Useful combinations
Load settings and parameters from a sheet
|
|||||
|
|
||||
|
|
|
||||
|
|
|
||||
|
|||||
|
|
||||
|
|
|
||||
|
|||||
|
|
|
||||
|
|||||
|
|
||||
|
|
||||
|
|
||||
|
|
||||
|
|||||
|
|
||||
|
|
||||
|
|
||||
This example is a short version of the Invoicing from timesheet app. After the current timesheet is loaded the Load cells building block is used to load individual parameters from a settings sheet within the timesheet worksheet. Most importantly the ${sendEmail} variable determines if the generated invoice should be sent to the customer who is billed. Of course you do not want this to happen while you are still working on your sheet and settings but only once everything reached a final state.
In this case also the email address of the customer is loaded from the settings sheet. For your case you can load any value from a cell within a worksheet and perform calculations or checks on the values.
Please make sure to set the correct language, time zone and currency both in Ultradox and Google Sheets so that your data can be loaded correctly and Ultradox will be able to produce the desired output. Further information under Internationalization.
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: 10/14/19