Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

One Button that references multiple record pickers.

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Preston_Swinche
5 - Automation Enthusiast
5 - Automation Enthusiast
Status: New Ideas

Passing multiple records into an automation by clicking on one button would enable a great deal of flexibility:

  • Dynamically linking multiple records, especially in junction tables
  • Passing information into one record that is taken from another record
  • Conditional execution of automation actions based on multiple inputs
  • Updating multiple records at the same time (eg. please edit both Record 1 and Record 5)

 

6 Comments
Jeff_Haskin
6 - Interface Innovator
6 - Interface Innovator

I have done this a couple times now, but it's different each time depending on what exactly you're doing.

If you give me a specific example, I can tell you how I've done it.

kuovonne
18 - Pluto
18 - Pluto

I believe that this feature request is to give automations access to the values in record pickers so they can be used as inputs to the automation without cluttering up the base schema with fields that are only used as temporary inputs.

Preston_Swinche
5 - Automation Enthusiast
5 - Automation Enthusiast

@kuovonne that is a better/cleaner way to do what I was envisioning, thank you!

Preston_Swinche
5 - Automation Enthusiast
5 - Automation Enthusiast

@Jeff_Haskin I'm using an interface to connect two tables via a junction table:

Table A -> [Junction Table 1] <- Table B

My interface features a record detail viewer of records in Table A. This feature would allow users to:

  1. view a record on Table A (thereby selecting one)
  2. choose a record on Table B via record picker
  3. Click Button: create a new record on [Junction Table 1] linking those records together.

My workaround right now involves a button that Flags the viewed record in table A (while unflagging all other records on table A). The user then selects from a Table B record picker. A second button is then clicked, which triggers an automation that:

  1. Finds all records on Table A that are Flagged (there should be only one)
  2. Creates a new record in [Junction Table 1]
  3. Links this new record to the Found Flagged record on Table A and the record chosen from Table B.

My team has preferred this workflow over some of the other "hackier" solutions we've played with. Would be open to any feedback if there's a cleaner way to do it! Thank you!

kuovonne
18 - Pluto
18 - Pluto

Your current method is risky if multiple people could be selecting records to make junction records at the same time. The wrong junction records could be created.

Instead of using the record picker, I would use a linked record field in Table A that links to Table B to hold the value of the record that will be in the junction table. Have the automation create the junction record using the trigger record in Table A and the linked record. After the automation creates the junction record, have it clear out the direct link field. This way multiple people can create junction records at the same time. It also eliminates the need for the "Find Records" action.

Preston_Swinche
5 - Automation Enthusiast
5 - Automation Enthusiast

@kuovonne thank you! That is a significantly cleaner way to handle this on interfaces. Was also easier to implement. I appreciate the help!