Skip to main content
Question

Change a record in one table when another table's record updates

  • March 26, 2024
  • 0 replies
  • 216 views
Forum|alt.badge.img+1

Hello!

I have a table called "Topic Repository" that lists out a training topics and how often we need to train on that topic. For example:

Topic Being Trained Training Cadence Required (Contract Requirement) Date of Most Recent Training
HIPAA Monthly X/XX/XXXX
Hospice Quarterly X/XX/XXXX
Diversity, Equity & Inclusion Yearly X/XX/XXXX

I have another table (in the same app) called "Training Records" that logs different trainings. For example:

Training Title Date of Training
Hospice 12/14/2023
Hospice 2/3/2024
HIPAA 8/10/2023
HIPAA 10/10/2023

I would like to create an automation/webhook/formula field, so that when a new record is added in "Training Records", that record's Date of Training it will update Date of Most Recent Training in "Topic Repository". It needs to only change this field if it's the most recent date.

One training topic in the repository can have many training records.

Does anyone know I can do this? I've watched so many videos online and have tried Webhooks, but am not sure how to execute.

Thank you very much!



------------------------------
Kim Nguyen
------------------------------

    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    I am hoping that you have set up your application properly so that there is a relationship where one Topic Repository has many Training Records.  If so, then easy, just go to that relationship  and create a summary of the "Maximum" of the Training Date field called [Date of Most Recent Training].

    If you do not have a relationship between those two tables but rather the training topic field in Training records is a shared multiple-choice field then you need to make a relationship. Post back if you want some help with that. It's quite easy actually.  



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement