I found your script in the below thread incredibly helpful – Thank you so much this is a game changer for me!
I’m curious if you might be able to help me make an adjustment to the script for a specific use-case which I think it broadly applicable to people needing to use a script similar to the one your created above.
I have translated my problem to match the verbiage in your Cake order example to make things more clear.
You can find the link to my example base here for your reference.
Right now the number of New Linked Records I am creating in my Cakes for Creation table is dependent on a Count Field which is adding up the number of Items linked in the “Cake Types” Field (See examples below):
Count Field Creation:
Example as Field:
In your example, rows created by the script in the “Cakes” Table are created based off the number of cakes in the “Orders” Table and then the user has to manually put in what cakes make up each order.
For example: the cakes in the Jackie Order are “unknown cakes” until the user would go like by line in each new cake and label it with it’s cake type (Like in the John Example).
Screenshots from my Example Base:
Unknown Cakes Created (In Orders Tab):
The Different Kinds of Cakes Making up the Order Types Table:
The problem in my workflow is that I receive the many orders at a time in the form of a spreadsheet.
The upside is that each order is labeled with the kind of cakes that makes up that order (This is what I use to create the Count Field which is leveraged by your current Script).
The downside is that is that labeling the new newly created “Unknown Cakes” for each order is very time consuming when there are dozens of orders and hundreds of cakes:
Labeling the Cakes is very important because it allows me to see how many of each cake need to create in a given time period so I can track my work properly!
NOTE: Manually labeling each Cake created also feels redundant as that information is already in my data-set (or would be created by an Airtable Form for creating New Orders for example):
Would it be possible for you to indicate how the script might be modified so that each new Linked Row in the Cakes For Creation Table is automatically labeled to match the corresponding Cake Type assigned to the order?
This would mean that the going straight to a table that looked something like this:
- From the “Orders Table” (Sorry about the typo):
- Cakes in the “Cakes For Creation” Table are automatically labeled with the kind of cake that needs to be created:
I think this would be a widely applicable script for many in the Airtable community who find ourselves in a similar situation to @Sheryl_Baptista in the original thread.
I am happy to be happy to try experimenting with this myself, but I don’t have very much code experience and a little guidance of the strategy for doing this would be extremely helpful!
Thank you in advance for any help you are able to give @kuovonne !