Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
4 years ago

Formula Query Syntax question?

Is it possible to have a text field that could be used inside the function query?

For example, suppose I had a field named Query, could I use a function query like this?

GetFieldValues(GetRecords([Query]))

------------------------------
Paul Peterson
------------------------------
formula queries
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Yes 

    Also you can do this as a best practice recommendation 

    var text QUERY = "{ query string goes here}";

    GetFieldValues(GetRecords([Query]), [_DBID_table_ alias])

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      4 years ago
      Thanks Mark!

      I think I may have found a better solution to my problem without using the Text field while working on another part of the table.  But that is good to know!

      ------------------------------
      Paul Peterson
      ------------------------------