Skip to main content
Question

Formula to Pull a single record field from another table.

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

    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