Hey! What type of field is the user selection? (Linked Record? Multiple Select?) If it's a linked record, you can use the Repeating Action feature within Automations to create a new record for each of the linked records.
Hey! What type of field is the user selection? (Linked Record? Multiple Select?) If it's a linked record, you can use the Repeating Action feature within Automations to create a new record for each of the linked records.
Hey Marcus!
yes, this is a linked record
That is, I need to create repeating logic that will select each one of the selected ones?
Hi,
I think, action with deleting will be easier.
Choose right trigger, maybe 'when record matches condition' - 'when responsible person contains comma'.
Use automation repeating group to loop through list and create record for each list item
add script step after the loop, with a record id value in left side, call it, for example record_id
let {record_id} = input.config();
let table=base.getTable('XYZ')
await table.deleteRecordAsync(record_id)or you can use oneliner
await base.getTable('XYZ').deleteRecordAsync(input.config().record_id)
Hi,
I think, action with deleting will be easier.
Choose right trigger, maybe 'when record matches condition' - 'when responsible person contains comma'.
Use automation repeating group to loop through list and create record for each list item
add script step after the loop, with a record id value in left side, call it, for example record_id
let {record_id} = input.config();
let table=base.getTable('XYZ')
await table.deleteRecordAsync(record_id)or you can use oneliner
await base.getTable('XYZ').deleteRecordAsync(input.config().record_id)
I agree with this if scripting is available on @flavich's plan.
Hi,
I think, action with deleting will be easier.
Choose right trigger, maybe 'when record matches condition' - 'when responsible person contains comma'.
Use automation repeating group to loop through list and create record for each list item
add script step after the loop, with a record id value in left side, call it, for example record_id
let {record_id} = input.config();
let table=base.getTable('XYZ')
await table.deleteRecordAsync(record_id)or you can use oneliner
await base.getTable('XYZ').deleteRecordAsync(input.config().record_id)
Hello!
I started trying your method, most of the automation was set up
Now I'm faced with the fact that in testing the trigger does not see a comma in the list of responsible persons
Tried this trigger - 'when record matches condition' - 'when responsible person contains comma'
I also tried to convert the field to text, but it didn't help, the comma is not recognized
What ways to solve the problem are there?
Hello!
I started trying your method, most of the automation was set up
Now I'm faced with the fact that in testing the trigger does not see a comma in the list of responsible persons
Tried this trigger - 'when record matches condition' - 'when responsible person contains comma'
I also tried to convert the field to text, but it didn't help, the comma is not recognized
What ways to solve the problem are there?
I didn't know your field type. If you use linked records, just add formula field with the name of linked field and use it in trigger.
I tried on test table and it works.
