I am trying to have a workflow trigger when a module import records through a CSV file. I tried using the trigger “Compose Record” for before and after create, but the system doesn’t catch the module importing records.
When I manually add a record, the workflow triggers. However, when I import a CSV file, while the new records are added, the workflow does not trigger. I also found out the default values for the fields are not set when the imported field is empty.
Is there a way for the workflow to trigger on record imports and mess around with the imported data?
@nutella I do something similar
since creating records from CSV would be a mess (mapping related records, overriding the empty fields), I do the following
I create a new module with a field of the type CSV file (only accept CSV type)
then I ran my automation for validating the CSV, filling out the missing fields, and then creating the record on the original module. lastly if everything is OK, I would delete the uploaded CSV