Hi, Glide Team
I am currently building an end to end production tracking system for a client in the fashion/boutique industry to streamline high volume garment workflows.
I have a Staff Table (for the tailors) and a Production Table (tracking the garments). My layout has a custom workflow button for payouts. It performs an Add Row to a Payment History table to log the payout amount and timestamp.
I am trying to cleanly archive/hide the garments that were just paid out so they disappear from the tailor’s “Unpaid” list instantly.
Currently, if I use a multi-step workflow that sets a temporary “Paid” trigger status, waits, and clears it, the garments flash off the screen but reappear once the trigger clears out (before the backend database locks in the history row).
What is the cleanest way to use the ‘Date Paid’ timestamp from the history table to filter the ‘True Unpaid Garments’ query? Glide’s date filter options seem restricted when filtering a query across tables.
Thanks in advance!