Pipelines: Lookup newest record?
Hi, In a Quickbase pipeline, I need to fetch a single record from a table. That record needs to be the newest record added to the table. I tried two common approaches but neither seems possible us...
One way to do this is to identify the Max Record ID# in native Quickbase first, you can do that by making a helper table with one record in it, and relating it to all records in the details table. With the formula field of 1.
Then do a Summary Maximum to get the Max Record ID#. Then you know in the pipeline which record to retrieve with a Lookup Record step.
