Skip to main content
Question

Filtering table with a list of mulitple values

  • June 22, 2023
  • 0 replies
  • 271 views

I have a field in my table that is of a randomly generated number for each record. I need to update another field of multiple records that are on a list of numbers that is created by someone else and sent to me that matches the randomly generated values on that table. This table has thousands of records so scrolling to find them all takes forever.

Is there a way to filter and show only the records I need to update by copy-pasting or importing the list of numbers I receive into a filter or formula. As of right now the only way is to type in the number in the search filter for that field and then update.



------------------------------
Bob Jones
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+15
    • DonLarson
    • Registered
    • June 22, 2023

    Bob,

    There is several ways to tackle this.  You are already doing the brute force method.  The most elegant is to write some code that would ingest the file and then update the records.

    There is a third way with Pipelines.  I would create another Quickbase application call it Vendor Data or something like that.   You do not even need any relationships.   Here is the structure

    You need three steps in your Pipeline.  It starts when you import records to the Vendor Data Table

    The Search Step finds the matching record by Random Number

    Then it updates the records in the Existing Table.

    Reach out if this does not make sense.



    ------------------------------
    Don Larson
    ------------------------------
    Terms & ConditionsAccessibility statement