This is actually a background check process. I have a database containing a list of background check items, and I want an API to assign a result to each newly copied child record.
At the same time, I want to have a dynamic field for balance. This means that when I purchase an item from the list, the background check will be activated. As I go through the process of assigning it to a candidate, I will have a copy of the selected background check items to assign accordingly. The newly created copies will be deducted from Table 1 until the balance reaches zero, at which point the customer will need to purchase again.
you need to use make for that. Check the build it with tim video about iterating thru connected records. from there you can probalby figure it out on your own.
if you are choosing items manually from a table/list then you may want to consider using “Action Button”. Screenshot is below, you can also include the arithmetic for balance tally. The action button is set to create a new record of the child (from Table 1) and inserts a copy of the child into another table (table 2). You can map the fields and copy across any field from T1 to T2
We have completed this process successfully with make vs native in Tadabase for several reasons. Conditions of what data needs to be part of the child record and the ability to get/extract the data from multiple tables as long as connections exists between the tables. We provide a complimentary 30 minute project review for Tadabase users. Please feel free to reach out at connect@rmelas.com.
