Forum Discussion

AleciaGipson1's avatar
AleciaGipson1
Qrew Trainee
7 years ago

VALUE OF ONE FIELD IS ALWAYS EQUAL TO VALUE OF ANOTHER IN SAME TABLE

I have an automation that is dependent on a record being modified.  My problem is the trigger field (it is a date formula field), when changed, doesn't update the "date modified" field.  I created a n...
Ask about Quickbase functionality
Discuss the community
Forms
AleciaGipson1's avatar
AleciaGipson1
Qrew Trainee
7 years ago
So the challenge I am facing is we have several tables that house different information about each employee.  Then all of those records come together in the "personnel" table that serves as an employee record and shows all information from different tables in one place.  Example:  John Smith has a record in personnel.  He has one event in the "citations" table, one event in "collision" table, etc..  All of those are displayed on the record form for "John Smith" in the personnel table.  We have a monitoring process built based on all of those summary fields from the different table (this was built prior to my coming on board).  In order to prevent the need to rebuild everything for time being I just need to "trigger" a training session (in training table) when criteria is met in the summary fields.  The only automation functions I can find are when a record is modified or added.  Since the personnel table record is basically a summary record I just need to figure out how to trigger that automation to trigger.  I tried setting an automation to update the current date field on a scheduled daily basis but there are too many records and it errors out.  Sorry for the novel it is just a complicated and inefficient build and I don't have the time to rebuild the entire thing right now. 
EricMohlman's avatar
EricMohlman
Quickbase Staff
7 years ago
Would an automation based on the details in your child table(s) be sufficient? i.e. a Citation is marked as complete could use an automation to create the training record elsewhere that's linked to the Personnel record, or a certification is expiring in the next 4 weeks could create the training record for recertification.

If you truly want it based on the Personnel record's summary fields, you could also setup formula fields to contain the details to send to the training session record, then create a table-to-table import targeting the correct information, and ultimately have a scheduled automation to send those details once the correct condition is met.