I feel like I've asked this before and found the answer before but I just spent another 20m looking for it. Here's the simplified version of what I want.
Goal, craft an email to your team with a list of the first, last, and birthday of everyone named Juan
Here's how I do it now.. EITHER:
- do a search for everyone named "Juan"
- create a variable to hold results in
- Create a script which starts at record one and loops through them all grabbing first name, last name, and date of birth
- send that email
This feels like a bit of work so lately I've been bypassing FIlemaker and using ExecuteSQL instead.. although I find that harder to debug and I'm definitely not a SQL pro.
Is there some easier command that basically just says "get this 4 fields from every found record"? I keep wanting ListValues to do this, but it doesn't seem to...