Hello! Got a case I haven\t figured out how to solve just yet.
Long story short:
Goal: update price in UI based on data not immediately available.
Workflow:
- User submits a document
- Document is processed via a N8N workflow and eventually the number of pages in the document is discovered and available. This process can take a while.
- The N8N workflow POSTS PageNum to the Adalo API and it’s saved in the DB.
- I’ve created a custom formula to calculate the price, it goes like this (bit simplified, but this is the logic):
[BASE PRICE] * [NUMBER OF PAGES] * [NUMBER OF ITEMS] = [TOTAL PRICE]
So… how do I retrieve the [NUMBER OF PAGES] from the Adalo DB on the fly and update the total price in the UI?