Skip to main content
Question

Extract Data from separate Table

  • May 3, 2023
  • 0 replies
  • 65 views

Hi,
Within my application, I'm looking importing data from a table into a form for calculation. Was trying to use the GetFieldValues(GetRecord    ) command to get a specific value from a table. Will work if I pass a fixed Record Identifier and required Field, but we need to be able to dynamically pass through the Record Identifier.
Is it possible to incorporate the value for Record Identifier as variable, which we can be dynamically as required.

Rgds
Pat 



------------------------------
Patrick O'Neill
------------------------------
    This topic has been closed for replies.

    BrianCafferelli
    Forum|alt.badge.img+17

    Hi Pat, yes there is a way you can use a dynamic record identifier instead. Consider this example:

    This formula will always get all records on the current table where the value in Field 50 is 2, and within those records, get a list of the data in Field 9: 

    GetFieldValues(GetRecords("{'50'.EX.'2'}"), 9)

    ---

    And this formula will dynamically get all records on the current table where the value in Field 50 is equal to the value in the current record's "Part Number" field, and within those records, get a list of the data in Field 9: 

    ToText(GetFieldValues(GetRecords("{'3'.EX.'" & [Part Number] & "'}"), 9))



    ------------------------------
    Brian Cafferelli
    Product Marketing Manager | Quickbase
    ------------------------------
    Brian Cafferelli Product Marketing Manager | Quickbase
    Terms & ConditionsAccessibility statement