Find all non empty fields?
Context: I'm pretty new to filemaker pro. I've got about 2000 fields which will be either blank or contain a comment by the end of the year. I'll need to regularly print out reports that contain all the comments made in those fields for each person in my database.
So my main problem is: how do I get filemaker to create a report that contains the name and contents of all the nonempty fields in a table.
Multiple searches about selecting all non empty fields have turned up nothing, so I figured I could make a script do the following:
select first field in a table.
if it's not empty, print the field name in the report, then print the text from the field into the report.
if It's empty, ignore it.
Move on the to the next field.
Repeat for every field in the table.
I can do the select first field, then select next field, and I can figure out how to loop it i think, but I can't seem to find a way to check if the selected field is not empty, and if it's not, then print its name and its contents in a report. Is that possible?