Retrieving DB data on the fly and update component live

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:

  1. User submits a document
  2. 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.
  3. The N8N workflow POSTS PageNum to the Adalo API and it’s saved in the DB.
  4. 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?

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.