I don't think it's a simple alteration I'm afraid. If you're trying to create a single record per record found in the linked table via an automation, you could combine a "Find record" action with a repeating group?
I'm not sure whether that's what you're trying to do though, apologies!
I don't think it's a simple alteration I'm afraid. If you're trying to create a single record per record found in the linked table via an automation, you could combine a "Find record" action with a repeating group?
I'm not sure whether that's what you're trying to do though, apologies!
Hi @TheTimeSavingCo thanks for taking the time to reply. I actually have a list of "confirmed events" table (from a sales perspective), and for each event, a list of "activities" (=multiple records linked from another table). My goal is to be able to have these "activities" listed individually in a new table where I can add for each activity the operational info needed for operational purposes (e.g: number of participants, start/end time...)
I tried the suggested solution above but it still returned multiple activities for each record and not individual records in separate rows
Mariem
Hi @TheTimeSavingCo thanks for taking the time to reply. I actually have a list of "confirmed events" table (from a sales perspective), and for each event, a list of "activities" (=multiple records linked from another table). My goal is to be able to have these "activities" listed individually in a new table where I can add for each activity the operational info needed for operational purposes (e.g: number of participants, start/end time...)
I tried the suggested solution above but it still returned multiple activities for each record and not individual records in separate rows
Mariem
Could you provide some screenshots of your tables and the way you set up your automation? I've set up what I think you're trying to do here and it seems to work fine:
