Thanks! Yes I agree, I have all her pages bookmarked and they are wonderful. I actually copy/pasted my formula directly off her tutorials, which is why I was so confused that this very simple task was not working.
However, I updated my original post, probably while you were responding. The error was not in my syntax. It was that I was trying to query in a different App, which is at this point not allowed.
------------------------------
Mike Tamoush
------------------------------
Original Message:
Sent: 01-19-2022 17:06
From: Laura Thacker
Subject: Basic formula query issues
Mike,
Quickbase Junkie has some amazingly helpful (and free) YouTube video's on Formula Queries. I HIGHLY recommend starting there for guidance.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
Original Message:
Sent: 01-19-2022 17:03
From: Mike Tamoush
Subject: Basic formula query issues
I've done formula queries before (still new, but can successfully make them work). I am banging my head against the wall trying to make something work. The actual goal is simpler than what I post below, but if I can get below to work, then I can achieve my ultimate goal.
This for me works:
Size(GetRecord(1))
Simply, get the count of record ID 1 in current table. The value of '1' is returned.
This does not work
Size(GetRecord(1,"dbid")
I assumed this would look in the table with the dbid id that matched for record ID 1, and return '1'. But it does not. I double checked that Record ID 1 exists and double checked the dbid ID. So i am assuming it is my syntax?
UPDATE: Disregard, as soon as i posted this I realized I was trying to query a table in a different app which doesn't work at this time.
What do I have wrong in this very basic formula?
------------------------------
Mike Tamoush
------------------------------