FileMaker Custom Function: RequestSQL
This custom function was brought to my attention the it’s creator, Caleb Miranda. Simple, and when you find a use for it, easy to implement:
This function has the purpose of retrieving a simple value from another table. It always seemed so obvious for me, but I didn’t find it before
The idea is, one provides the field from which the value they desire – fieldDesired –, the field to search from – fieldKey – and the value that the fieldKey has – valueKey
Sample input: RequestSQL(customers::name;customer::CustomerAge;35)
Sample Output: the name of all the customers whose age is 35
I like it!
FileMaker Custom Function:RequestSQL ( fieldDesired ; fieldKey ; valueKey ).
Like
0
Liked
Liked
July 30, 2014 @ 12:02 am
Pity, but it only works for the current table.
It hinted that it would work across unrelated tables.
August 8, 2014 @ 10:46 am
Well, I’m the author of the function, and I do not understand what you mean. It doesn’t require any relationship with the tables for the result to be brought back.
Please, contact me if you have a specific use case in which it fails
caleb.miranda@gmail.com
August 16, 2014 @ 10:12 pm
Is it me or doesn’t it work at all now?
Maybe I’m doing something wrong? e.g. RequestSQL ( Contact::ContactFullName ; Contact::ContactID ; 63 ) gives me a “?”. I have tried different tables and fields but just keep getting a “?”.
Also it now slows down Filemaker including a long time to calculate a calculation field with this function.
I would love to use this CF. Any help would be greatly appreciated.