Hello,
I am unable to handle an error in my scenario, I am collecting data through a tally form in the collected data there is the option to add 3 attachments or these attachments are optional so when an attachment is missing the module “create database item” does not execute, I would like to set up a rule which uses the URL of the attachment if it is available and which would ignore it if it is absent.
I don’t want to ignore the module but only use the URL data if it is not present.
I tried using “generales functions” but without success: {{ifempty(3.fields.Attachment #3 .url)}}{{(ignore)}}
thank you for the solution but if I do that I end up with 11 outputs on my router, right? The Tally form contains 3 attachments and so I have to anticipate all cases, for example attachment n°1 is missing and n°2 and n°3 are present, case 2 n°1 and n°2 are absent and n°3 is present…
I understand and I agree this can become clunky (see below the line for a different approach). If you follow this approach, you would need 4 Routes as far as I can tell (and some if statements): one for when there is no file; one for when there is 1 file; one for when there are two files; one for where there are three files.
On each route, you can filter with this logic:
{{attachment 1}} does not exist & {{attachment 2}} does not exist & {{attachment 3}} does not exist
{{attachment 1}} EXISTS & {{attachment 2}} does not exist & {{attachment 3}} does not exist OR {{attachment 1}} does not exist & {{attachment 2}} EXISTS & {{attachment 3}} does not exist OR {{attachment 1}} does not exist & {{attachment 2}} does not exist & {{attachment 3}} EXISTS
→ then you can use if statements in the File Notion property to map the one attachment that EXISTS
{{attachment 1}} EXISTS & {{attachment 2}} EXISTS & {{attachment 3}} does not exist OR {{attachment 1}} does not exist & {{attachment 2}} EXISTS & {{attachment 3}} EXISTS OR {{attachment 1}} EXISTS & {{attachment 2}} does not exist & {{attachment 3}} EXISTS
→ then you can use if statements in the File Notion property to map the one attachment that EXISTS
APPROACH 2 → Create only 1 File Upload field in Tally (and allow multiple files upload–you can also set a limit of 3 files). Use JSON Aggregation to upload one or multiple files at once in Notion.
In this case, create two routes:
If no file exists → all the steps you have, and do not map any files in your Notion module
Thank you very much for the quality of your answer.
I tested the first approach but I’m stuck on the part of using if statements, I’m having trouble generating the functions with all the conditions provided.
On the other hand I was able to set up my scenario with approach 2, I had to do some workarounds to recover data other than attachments and the case where no attachment was transmitted, but it works.
If you ever have a little more content on the management of general functions within the framework of approach 1, I am interested, I would like to succeed in the 2 approaches but otherwise I thank you once again because thanks to your help my scenario is operational
