Forum Discussion

BradElmore's avatar
BradElmore
Qrew Assistant Captain
2 months ago

Formula Query (Size) - Question

I have created the following Number Formula query in Table A:

My goal is to calculate the total records in 5 non-related Tables. The [Table Alais] field represents the Table Alais for the 5 different tables -- and the [AlaisTableFieldID] is my query field. This formula is not working.....any advice is appreciated.

Size(GetRecords("{"&[AlaisTableFieldID]&".EX.'"&[Record ID#]&"'}","&[Table Alais]&"))

  • Any chance your use of "Alais" instead of "Alias" is breaking your formula?   Did you define the variables differently further up in the field?

  • Can you explain again what you are trying to do here?  Are you saying you just want the record count in a table?

    Size(GetRecords("{3.GT.0}", [Table Alais]))