I haveTable Awith a list of suppliers,Table Bwith a list of generic products (linked to multiple suppliers from Table A), andTable Cwith a list of specific productslinked to a specific generic product from Table B and a specific supplier from Table A.
I would like fromTable Bthatwhen I add a new supplier to a generic product(in the supplier field linked to multiple suppliers), itautomatically creates a new record inTable C, with the specific supplier associated to the generic product.
Jan 23, 202306:07 AM - edited Jan 23, 202306:09 AM
An automation with a "Run a script" action would be simplest if you know how to do that / know someone who could help you with that
If not, an alternative is to force the creation of new records by pasting unique comma separated values into a linked field, and you can find an example of that here
The example works by: 1. Having an automation that finds the relevant template records and pastes them into a specific text field 2. Having a formula field that will format it into a unique comma separated list of values 3. Having another automation that will then paste the values from the previous point into a linked field, forcing multiple record creation
In your case, I think you could trigger the automation when the supplier gets added to the product, look for all the products that that supplier is linked to and paste that into said specific text field from step 1 above
And if you're open to third party options, Zapier's got a line item action that may help with this as well I think