Skip to main content
Question

Formula to Pull a single record field from another table.

  • March 1, 2024
  • 0 replies
  • 934 views
Forum|alt.badge.img+1

I am trying to build a formula that pulls a single record via a unique field, I want to pull just a single field regardless if there are several records that match my search query. My current formula's I am trying are;

GetFieldValues(GetRecordByUniqueField([Record ID#], 7, [_DB_Alias]), 6) this formula fails as it sees a textlist from my understanding that is multiple records instead of a single record,

 GetFieldValues(GetRecords("{7.EX.[Record ID#]}&options=num-1",[_DB_Alias]),6) this fails for the same reason as I am pulling multiple records via the GetRecords function but applied the limit of num-1 as an option.

Neither work and I would like to pull only a single record with a single field back using either of these functions.



------------------------------
Colin Burns
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • March 1, 2024

    Formula queries don't accept that kind of parameter to only bring back one record at this time. Your best best is to get the results you want and then do a Part([Res], 1, ";") to get the first occurrence in the response. 



    ------------------------------
    Chayce Duncan
    ------------------------------
    Terms & ConditionsAccessibility statement