Forum Discussion

PatrickO_Neill's avatar
PatrickO_Neill
Qrew Member
12 months ago

Extract Data from separate Table

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
------------------------------

1 Reply

Sort By
  • BrianCafferelli's avatar
    BrianCafferelli
    Qrew Captain
    12 months ago

    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
    ------------------------------