Re: Add only the latest attachment through automation
Hi,
I want to be able to upload documents in one table. These documents are usually invoices and should be uploaded to the correct supplier. When I upload a new document, I want to create a new record in a different table, for each attachment that is being uploaded.
Currently, when I run it it creates a new record but the new record contains previous uploaded attachments too. How can I ensure that it is only the latest uploaded attachment that is being created as a new record?
When I bulk upload, it also creates only one record. How can I make sure that it creates one record for each attachment that is being uploaded?
Here is the current trigger:
Here is the current action:
Accepted Solutions
Hi,
you can apply ‘low-code’ approach. to get last element of array, use method ‘pop’.
between trigger and ‘create record’, install simple script step.
You should pass this array, as input parameter with any name (I used ‘urls’)
input parameters located in ‘input.config()’
then you should pass output element, assigning it to some variable. you can use this variable in next steps.
so:
const single=input.config().urls.pop();
output.set(‘url’,single);
that’s how similar setup looks like:
after that, use this variable ‘url’ in further steps, as you usually do with values.
Actually, you can do the same without code by creating additional mini-table with extracting last url from array, by text formulas, and then at next step take your value. But I think solution without extra table is better.
Hi,
you can apply ‘low-code’ approach. to get last element of array, use method ‘pop’.
between trigger and ‘create record’, install simple script step.
You should pass this array, as input parameter with any name (I used ‘urls’)
input parameters located in ‘input.config()’
then you should pass output element, assigning it to some variable. you can use this variable in next steps.
so:
const single=input.config().urls.pop();
output.set(‘url’,single);
that’s how similar setup looks like:
after that, use this variable ‘url’ in further steps, as you usually do with values.
Actually, you can do the same without code by creating additional mini-table with extracting last url from array, by text formulas, and then at next step take your value. But I think solution without extra table is better.
