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 ).

 

Liked Liked
Need FileMaker Development Help? Or to purchase FileMaker Software?
Contact FM Pro Gurus for help