Hi. I,m trying to filter records using filter formula based on record_id. The field is not exists in the table, and we don't want to create formula field to have record ids explicitly. Is there a way to compose query formula to filter data by their r...
I found the solution, Just instead of {record_id} I used {RECORD_ID()} function in query like this:AND(OR(SEARCH(",recctaxd2aq9fvtfj,", "," & SUBSTITUTE(LOWER(ARRAYJOIN({RECORD_ID()}) & ","), ", ", ","))))
OK. this is my demo table, which has several records. I do not defined recordid field for my records, but as we know each record has record id like this "recctaxd2aq9fvtfj". So in my application I have conditional filters to fetch data from table by ...
