Forum Discussion

Qrew Cadet

3 years ago

How to make my automation repeat X times

Hi I have a button that adds a child record to a table with various data from the related table. It's involves three tables: a Company, Quote and Asset. When products quoted turn into a sale...

Pipelines

Quickbase Automations

MarkShnier__You

Qrew Legend

... So does one Order have many Quote lines and the current process is to "push" the button on each quote line. ... and the desired button would be on the order?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

KimG

Qrew Cadet

3 years ago

No, it doesn't work quite like that. I guess I do need to mention a 4th table related to Product - that is Model. So when someone creates a quote, there's a multi-select field where they can pick Product names. Based on this, further fields will appear to select from the models available, and other options related to each product. (When equipment is first quoted they may not know which model; this info doesn't have to be selected initially but must be filled in prior to the quote closing as won at which time the magic button is clicked and the asset created.) So it's perhaps more clunky than relating a list of products to the quote.

There are actually multiple buttons depending on what is quoted because I couldn't figure out an easy way to account for all the items in one button. So if on the quote Product A and Product B are listed, then they would see two buttons, "Add Asset Product A" and "Add Asset Product B". Each product has its own checkbox and own automation. The "Add Asset Product A" runs an automation for that asset, and so forth. So if someone is buying Product A and B then you would need to click two buttons. If someone is buying 2 of only Product A, then you would need to click the "Add product A" button twice. It's this case that is the issue. We have some customers by 30+ of Product A. I would expect to add a "Quantity of Product A" field to the form that would get used in the automation.

Kim Gardner | Marketing & Communications Coordinator | Comco Inc.

Direct: 1-818-333-8514 | Main: 1-818-841-5500

2151 North Lincoln Street | Burbank, CA 91504

We make your life a blast!

JeremyMyer
Qrew Trainee
3 years ago
I have a similar use case where for any given Test, I need to add Sample Parts. I have an automation that loops as Kim mentions with a 'counter' & 'next counter' field to achieve the X new Sample Part records. I have it working, however the processing time for adding new records 1x1 is quite slow, and takes several screen refreshes to get all the records to show.

I've been working with QB to get a better solution, namely a bulk record upsert to created all the records in the background, then immediately show all X records at once. I was pointed toward this app, but haven't had a chance to play with it and get the logic working in my app. It's in the app exchange - "Create X Children"
https://nsk.quickbase.com/db/main?a=AppDetail&ID=4093&app_name=Pipelines%20-%20Create%20X%20Children

Just thought I'd post this in case you find it helpful.

------------------------------
Jeremy Myer
------------------------------
- KimG
  Qrew Cadet
  3 years ago
  Thanks for the tip, Jeremy. I'll check out the app. For my application having the child records appear immediately isn't super critical. They do get modified, at a later time when equipment ships and ship date and serial numbers are recorded. However, it's always reassuring to see that it's worked and they are there in the database, so needing several screen refreshes to see them is annoying.
  
  ------------------------------
  Kim G
  ------------------------------