teacher trying to help but in over his head.
I am school teacher working overseas at a small international school that is many years behind in tech. I am attempting to teach myself how to use FM Pro to gather teacher report card info (excel files) into one FMP file and then automate the mailing of PDF report cards. So, my to hurdles at the moment are:
1) I need FM to make a PDF file of each record and email using the parent email address field by running through all records.
I called FM tech support and got some help on how to set up a basic loop but was told I would need to learn how to use a variable to complete the script.
Can you take a look at the script I have so far and tell me what I need to type in to complete the task.
Here is a link to my script so far:
2) What would be the best way for me to merge/import multiple teachers data. My thought is that instead of having all teachers send me their individual files we could us a Google shared Excel doc and then I could import that into FM Pro (I am the only person with FM Pro at the school so they have to use Excel).
3) Once all the data is into FM Pro I dont know how to solve the issue of makig FM Pro skip those fields that are empty (classes the student is not taking) and only import into the classes they have data for. In other words, my form is repeated down 8 sheets, the average number of classes a student has. But then again, I don't want to generate blank pages either, is there a way to only make FM Pro have a merge the resulting PDF only ude those pages that get their merge fields completed? Is the answer something like a 'conditional merge' field? e.g. IF field >0 then get field data or IF field contains text then get field data?