Automation Flows: How to Correlate and Validate House Note and CPS Note Submissions

Subject: Assistance Needed: Automation Flow to Correlate House Notes & CPS Notes

Hello,

I need assistance setting up an automation flow in JotForm that correlates two different forms: our House Note submission and our CPS Note submission. We need the system to automatically check whether both notes were submitted for the same staff, same client, and same date — and whether the time ranges match correctly without overlapping.

Here is what we need the automation to do:

1. When a House Note is submitted, the system should check:

• Was a CPS note also submitted for the same client and date
• Do the time ranges match correctly
• Example: House Note 8am–4pm
• CPS Note should be 4pm–12am (or vice‑versa)
• No overlapping time blocks
• Content fields are completed correctly

2. When a CPS Note is submitted, the system should check:

• Was the House Note for that day already submitted
• Do the time ranges connect properly
• No duplicated or overlapping hours
• Content is complete and accurate

3. Based on these checks, the automation should route the submission to:

• Approved
• Denied
• Needs Correction
• Missing Matching Note (if the other note was not submitted)

4. We need guidance on how to build this logic inside JotForm Automation Flows:

Specifically:

• How to compare two different form submissions
• How to match by client name, date, and staff
• How to compare time ranges between two forms
• How to trigger approval/denial based on missing or mismatched time blocks
• How to prevent submissions from going to the inbox instead of the submission table

This workflow is essential for compliance and documentation accuracy. Please advise on the correct setup or provide direct support to help us build this automation properly.

Here is what I think might work

🧩 AUTOMATION BLUEPRINT: Correlating House Notes & CPS Notes

Step 1 — Both forms must have these fields identical:

• Client Name
• Staff Name
• Date of Service
• Start Time
• End Time

This allows JotForm Tables to “match” submissions.

Step 2 — Create a JotForm Table with a “Connected Table”

You will connect:

• House Note Table
• CPS Note Table

Use Linked Records to match by:

• Client
• Date

This is how JotForm can “see” whether the other note exists.

Step 3 — Add a Formula Column to check time correlation

Example formula:

IF( {House End Time} = {CPS Start Time}, "Correct", "Mismatch" )

You can also check for overlap:

IF( {House End Time} > {CPS Start Time}, "Overlap", "OK" )

Step 4 — Add a Status Column

Statuses:

• Approved
• Denied
• Missing Matching Note
• Time Mismatch
• Overlap
• Needs Correction

Step 5 — Build Automation Flow

Trigger:

When a submission is added OR updated in either table

Conditions:

• If matching note exists AND time blocks connect → Approve
• If matching note exists BUT time blocks overlap → Deny
• If matching note does NOT exist → Flag as Missing
• If content fields incomplete → Needs Correction

Once staff is notified and complete the note I want the system to update

I also want it to text and email we the submission. Can you do this for me

Links below

CPS note

https://form.jotform.com/260615094518155 

https://form.jotform.com/260614733976162 House Note

Hello Tahira,

Thanks for using Jotform. Currently, Workflows cannot directly compare two separate form submissions. Workflows can only trigger actions based on a single form’s submission, so matching by client, staff, and date, and validating time ranges across two different forms is not possible within Jotform.

As a workaround, you can merge forms using the Combine Submissions tool, then import their data into the same tab in Jotform Tables for easy viewing. First, let me show you how to use the Combine Submissions tool: 

1. Go to Combine Submissions page, click the on the Start Combining button.
2. In the window that pops-up, click on the Allow button.
3. In the list that comes up, select your form, and next to it, choose the fields that you want to merge. To select all fields, click on the Select All box.
4. Then, click on the Generate CSV File button and use the link below it to download the CSV file.

Now, let's import the merged CSV file to the Jotform Tables:

1. On your My Tables page, click on Create Table on the upper-right side of the page.
2. Select Import Data, and click on Upload File and select your file, or simply drag and drop your file.
3. Toggle On the Set The First Row As Column Headers option, and click on the Short Text option to change your column types.
4. After setting the column types, click on the Import Data button.

Check out the screencast below to see how it'll look like:

Keep in mind that this merged table won't update automatically, so it only includes past submissions. You'll need to repeat the steps again to refresh it with new data. This setup allows you to easily view and compare submissions side by side, and you can then apply filters or views to highlight missing or incorrect notes.

Notifications such as emails or texts would still require integration with third‑party services like Zapier or Twilio, but the combined table will give you a clear, centralized way to manage and validate your records.

While that feature isn’t available in Jotform right now, I’ve sent your request to our Developers for review. When or if it gets developed will depend on their current workload, how possible it is, and how much demand there is from other users. If/when we have any updates, we’ll follow up here and keep you posted.