Aug 01, 2020 03:41 PM
User Flow:
I have three tables and am following a traditional Relational Database logic:
I have linked all tables correctly, all works well, etc.etc.
Where I am stuck completley, is that I want to be able to somehow automatically generate what is called a VIEW in Relational Database language (or virtual table) that JOINS the records in all three tables using ORDER number (which is correctly linked in every table).
I’ve spent 4 hours trying to figure it out, doing more lookups, rollups , etc., but the thing is, I want the VIEW (Virtual table) to update automatically so that I can then use that view to have a consolidated view of each order , when it was placed, how many QC checks it went through, and when it was shipped.
Aug 01, 2020 04:14 PM
Any automations would need to be scripted with JavaScript using the scripting block, which you could then trigger via the new automations beta or the button field.
Or, my preferred way of automating things is using Integromat, because it’s easy & no JavaScript is required!