Interesting! @Alexey_Gusev’s solution should work for your needs I think. One refinement I would suggest is that, if the
Jobs 2 table has a date field that you get from Oracle, I would match that date to the creation dates of the submitted forms instead of using “Yesterday”, thus allowing you to import the Oracle data on the same day as the form submissions.
Personally, I wouldn’t even use an automation for this as they’re way too precious of a resource for me right now heh.
Instead, I’d just paste formatted values from the Oracle data table into a field that’s linked to the Form Submissions table. The idea is for the Form Submissions table to have a formula field as the primary field, where the format is:
[Creation Date of Record] - [Account Number]
And the Oracle table will have a similar field, except with the date from Oracle:
[Date from Oracle] - [Account Number]
You’d then paste those values into a field that’s linked to the Form Submissions table.
If the Form Submissions table has a record that matches exactly, e.g. 24 May 2022 - 1, then the value gets pasted in. If the Form Submissions table does not, then the paste will be unsuccessful, leaving you with an empty field
We then have a “Status” field that outputs “Submitted” or “Missing” based on whether the link field is empty.
Here’s a gif of it working:
I’ve also get it set up here in case you’d like to see it. To view the setup (formulas, automations etc), duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button.
Happy to answer any questions you have