swpowe

I'm trying to use FMP to track class/student attendance. I've got my classes and students setup and what I'd like to do is be able to enter in who attendend what class and then run a report saying average attendance is...I'd also like to run a simiilar report sayind "john smith attendended an average of ..." make sense? Anyone know how to do this? I'm trying to use a check box for a simple check meaning "yes" and unchecked for "no" on attendance. Thanks for all the help!

I'm trying to create a database for some sound effects and I'm running into problems with the network aspect. I've got some sound effects on a network share and I've got my container fiedls with a reference to those files and everything works on my machine but if I open the database on another machine on the network it doesn't play the files...the link is broken. How can I view the link or change the link of a container field? is it even possible to do this? I can't store the files in the database for a couple reasons but one of which is it would be huge. thanks for the help!

I'm trying to work of the "tasks" template to create a database that will allow me to have multiple projects and each project having it's own multiple tasks. The problem I run into is importing my tasks from an excel spreadsheet. I need to be able to either create a project or assign tasks two a project while importing from my spreaadsheet. I've got spreadsheets that have many lines of "tasks" and then infor for each task and I need to be able to put those tasks under a project. I can't seem to figure it out. If I import them to the "tasks" table in the template it doesn't create a project and I can't figure out a way to import while i'm looking at the "project" page. As I'm sure you can tell I'm kind of a newbie at this. thanks for any and all help on this.

I don't think I have it setup right...forgive me for not having too much experiance with this. I created a script that looks like your script up above (for my find request) but i'm not sure how to search multiple fields and return any request that meets the global drop down value. Would I just duplicate the "set field" line and reference each of the 5 fields I want to search? For my original 2nd question..would you have an example of an if then statement I could use? I'm not too familiar with if then statements. Thanks!

Nevermind. I got it to work...not sure what I was doing wrong but it is working now. Thanks!

Thank you!! That is what I'm looking for. Is it possible to add additional fields to the log? I tried creating a new field and adding it to the calculation but it just returned a "0". Any ideas what I may be doing wrong? I basically duplicated the "a.text" line only changing it to my field name. Thanks again for the help!!

I would like to keep a history or log of remarks that are entered into a specific field. Is it possible to allow a specific user to create a remark and then once they have left that field the remark cannot be modified? I need a history for a helpdesk like application. I need to be able to see all the remarks that have been entered as well as the date. Thanks for the help!

I hope I'm in the right place...I'm using FMP ver7 and I'm trying to do two things. The first is, I've got a button that when clicks runs a script that does a simple search and returns all fields that match a specific criteria that is built into the script...instead of having the specific criteria say all fields that have the word "recorded" in them...I want to have that populated by a drop down list so i don't have to have a button for each report I can just have one button and a drop down that will allow me to select the variable I want to search for. Make sense? My next question is this. I also would like to have a button that would run a script that looks at a specific field and if that field name matches the name of a layout it would go to that layout but if there is not a layout by that name it would return a message saying such. I appreciate all the help I can get on this. Thanks!