swf

Exactly what I want. Even after reviewing your script I am unable to figure out how you removed the duplicates. ie john 3, john 2, john 1 to leave only john 3. I suspect it involves the # sign but I am not sure. An explanantion would be great. thanks

I have posted a sample file with students who take two different certifications A and B. Each students takes 4 tests for A and 4 tests for B. I want to be able to print out a report for certification A and certification B showing progress of each student. Ie. which student completed 1 or 2 or 3 tests. Students should only be in one category for each certification (ie the maximum test number). Report would be certification a, test 1 student names with total, test 2 student names with total etc. Then certification b , test 1 student names with total etc. studentstest.fp7.zip

I have filemaker 8.0 and am not planning to upgrade. I need to go to a website and wrote a script go to url that works great. Next step is to automatically log in if possible and also enter the name of the current client into the first field of the website. the website is another database with the same clients as my filemaker database. eg. on client jones in filemaker I want to go to www.alternatedatabase.com and automatically enter jones on the first field of the web database. I though i could do this with a query statement. thanks

Here is a sample database(simpler) that demonstrates how to find the last date. It uses max function to find the most recent date. recentdate.fp7.zip

I attached a samplefile. I want a field to update based on the last portal entry. I have created a relationship to isolate the last portal record. If I create a calculated field it works fine. However, I would rather a regular field that autoenters with the same calculation. The reason is simple. The field will usually but not always be based on the last portal and the user may need to override the calculation. Please take a look. test.fp7.zip

I recently update server to 8v4 and clients to 8v3 to get rid of broken indexing. I still can't get my scripts to print to the right printer AND with the right format (portrait vs landscape). I have different layouts that produce different forms. I make printing buttons for the staff so they do not have to memorize which printer has the right paper and which way it faces. The script that is triggered is set for the printer and orientation but usually goes back to the last last orientation used. Anyone have any new ideas other than manually using a dialog box each time. I do not want to use a plugin. I feel that this should be fixed by the 8th generation of a program.

I think you are looking for a portal to show a one to many relationship. Then a filtered portal would then limit the data to the records with a specific value. Attached is a list of students and grades in many classes. Then I filtered a portal to show only classes where the students received an "a". Hope this is the right direction. filterportal_Copy.fp7.zip

To clarify, what I was trying to avoid was months that are too short leading to errors. I don't want to add 90 days to November 30 as this could become March instead of Feb (since the month is short). That is why I wanted to extract the month and add 3 months and then convert back to the name for the report. People like to see sept not 9 on the printout. You have both given me some ways to approach this. Thank you.

I am trying to flag an event every quarter. Filemaker finds the most recent event using max function and using month function calculatest the month. eg 6/10/05 becomes june or 6. Now I want to add 3 months and get 9. Can I convert the 9 back to september with a function or do I need to lookup a table of months and numbers 1 jan 2 feb etc.

Your technique works great. I made a sample file for review using it. I even extended it to 3 levels of data. eg. fruit banana ripe value.fp7.zip

There have been some recent descriptions of a bug in version 8 which messes up the index. I had a similar problem of records not found and reindexing solved my problem. Try searching the forum for indexing errors. Any other thoughts?

I realize it would be a security concern. But I don't want to know the password just have person enter their password. If it is correct then the script would proceed, if not the script would give an error. That way you could have electronic signature as secure as the logon process.

That is a question I have had for a long time. Is there a way to have a password entered and then compare it to their filemaker password. I could not find any function to perform this. It is easy to get current user or account but not password.

I have a similar solution based on relationships. It requires the use of a refresh script to redo all the calculations when new data is added. I would like to improve it in 2 ways. 1) refresh without having to use the script 2) set up another TO with relationship to isolate the finish line entries. (the maximum of the timestamp and the odometer.) For reporting purpose the user wants each bike number and the overall mpg. Each and every data point is not helpful in the final report. I am sure someone can easily fix this up. bike_Copy_1.fp7.zip

I am having trouble with indexing of a portal. first my portal starting showing extra blank records. Now some of my portals are broken with no records showing up. My search of the forum suggests I might need to upgrade from filemaker 8 to 8.2 and the same with filemaker server. Is the right approach? Do I just download the new versions from filemaker or do I need a new cd? It has been working great for over 6 months before this. I upgraded to filemaker 8 about 6 weeks ago.

I have posted a demo file for some feedback. I need to lock data entry in a field depending on user privilege. privilege from low to high is user1 (level 1), user 2 (level 2) and admin. Level1(user1) can only enter the data but not sign the checkbox. Once user2 signs on he can change the data (if necessary) and sign the signaturecheckbox. Checking the box is irreversible. These restrictions are accomplished by privilege sets validated by an empty checkbox. user1 can only enter field (order) if signature checkbox is empty. As a final step once user2 signs the checkbox I want to give a limited amount of time to make revisions and then the record is permanent. I created a timestamp when the box is checked. timelock should automatically turn to 1 when the elapsed time has passed. As a test this is set to 40. When timestamp changes to 1 user2 is locked out of the fields by privilege set validation. However, when testing this after 10-12 seconds the field locks out for user2. It should wait until 40. Anybody have any ideas? let me know if I should explain more. sigdemo.fp7.zip

I have tried very hard to normalize my data and have entries in line item table. However, sometimes you want to manipulate the data to look different for reporting an a line item is not the best way. In the attached file does anyone know how to convert the top into the bottom table. I need to export into excel (a subsummary report is not helpful) to send in a mandated report.

when you define the field options, go under storage. check the box Do Not Store. This will make it recalculate each time. good luck.

I have fm server (server 8) running on a separate machine and several client machines connecting with fm 8. I have several global fields used in a relationship to filter records. when I put the data in the global field it shows up in all the records and the relationship works great. Everytime I log off the database and reconnect the global field is blank and the relationship no longer works. any ideas?

I have been searching the forum for some time. I thought there might be a script that automates the process of manually importing each table and resetting the serial number when copying into a clone. It is time consuming to do this for each table. Thanks

I did save as a compacted file and now the file works. I will try to figure out how to check the server log tomorrow when I am back at work. I also was able to change the default backup filepath to match my previous one. (I did not want to rewrite the backup program). I was not able to change the default filepath where server looks for databases. Thanks for all the advice.

I have had filemaker server 7 running for many months without problem. I upgraded to server 8 today following the steps in exact order. No trouble with that but I have two problems. 1) I need to change the default folder that filemaker server looks in for the databases. The backup program is set to look in the old folder from filemaker 7. 2) 2 of my 3 databases work fine. The 3rd is present but "closed". Trying to open it continually fails. I checked the sharing of the file and it is on for tcp/ip but the "all user" checkbox is greyed out. Is the file corrupted? When connecting via a client this file is not listed as an option. Thanks for any advice.

It is called a one to many relationship. open the sample file You have clients A,B,C,D Client A has contact 5,6,7 Client B has contact 1 Client D has contact 2,3,4 Make a table for clients Make a table for contacts and create a relationship between clientid (this is also know as primary and foreign key) Also search for "one to many relationship" on the forum and on google.com. Notice that the contact layout shows the clients name as a,b,c,d. This is taken from the other table. Try this. Change client 1 name from A to E and look back at the contact list. Contact 5,6,7 should now show E as the client name. many.fp7.zip

I am using word 11.2 for mac. The mail merge has a built in filemaker import wizard. You create your labels, then get data source and one choice is filemaker pro file. However when it browses the desktop for my filemaker file, it is right there but greyed out and not available. Has anyone seen this or had this work successfully. does it involve upgrading to filemaker 8? I was able to get the data into excel and then from excel into word, but it took several extra steps and some reformatting.

Take a look at the attached file. It has both options. One set of field "lookups" the id and name of the user, storing it at the time of entry and it will not change. The second set of fields are based on the relationship from the user table and if you change the user or delete them the related table data will change or be deleted. It shows the two ways to use the relationship. Best example of this is that an invoice has to reflect price at the time of the purchase whereas price list has to reflect current price. Take a look at the file and record 4. In this case the user was originally carl and was changed to jack. However the lookup value says carl but the related value now shows jack. record.fp7.zip