FYI I tried to add this to the Filemaker community page but don't think it worked hence adding here also.
I have been tasked with creating a website for a charity, part of the website will be a searchable archive of all of their historic data. This data is stored in Filemaker Pro 12 on the historians machine.
He has provided me with 4 .fmp12 files, I downloaded a trial version that I found here http://www.filemaker.com/redirects/ss.html?file=PRO12MAC however none of his files will open.
The website runs on Wordpress which is php based, the database is a maria database although I am happy to use whatever method I need to get this data on to the website and searchable.
I was expecting to open the files in the trial version, export as csv and create and import in to the maria database.
Is this possible with filemaker, do you think I would be better downloading a trial of the latest version, will his files open ok in the latest version?
Unfortunately I have no experience of filemaker so am struggling a little.
Thanks for any advice anyone may be able to provide.
I would like to have options to enter either fields (selling price or margin) and the other should be automatically calculated for instance:
Cost Price = 100 (Available)
Sell Price = Calculation field or ?? Input amount
Margin = Calculation field or ?? Input percentage
If i put 160 on sell price it should automatically put 37.5% in margin or if i put 37.5% in margin field it should automatically fill sell price for 160.
Login name: admin
Thank you in advanced.
By John Link
I have FileMaker Pro 12 installed on four computers on my network, and FileMaker Pro Advanced 12 stored on a fifth computer. There is a shared database stored on one of the first four computers. When using the shared database from the fifth computer and I attempt to check any of the checkboxes for the field Events, I see the message shown in the attachment and I am unable to check the checkbox (This behavior occurs only on the fifth computer). If I then do a search, after doing the search I am able to check any of the checkboxes in the previously problematic field. I've restarted the fifth computer and the problematic behavior stills occurs.
Having been shown the bug in 10.11.6 and FMP by bcooney I am setting up the Send Mail script to send via SMTP. This works OK in the Invoice table but I can not get it to work in the Quotes table. There does not appear to be anything in the mail setup script that is capable of creating the error and I have tried three different smtp server addresses with the same result. I have used all three smtp server addresses on the Invoice table as well and they all work. Can anyone assist please.
By Steve Martino
Hello Forum. I had some basic questions (for starters) about a report I am trying to create:
1. Can this type of report be created?
2. Can you point me in the right direction.
I have the following tables: People connected to both Readings and Sessions with the usual primary key-foreign key relationship
I would like to generate a report for a person, with 1 Reading record, then Session records after that Reading record timestamp, then another Reading record, etc.
So basically it would look like this:
August 1 9:00:00 am (Reading record)
August 2 10:00:00 am (Sessions Record)
August 3 10:00:00 am (Sessions Record)
August 4 10:00:00 am (Sessions Record)
August 5 10:00:00 am (Sessions Record)
August 6 9:00:00 am (Reading Record)
August 6 10:00:00 am (Sessions Record)
August 7 10:00:00 am (Sessions Record)
August 8 10:00:00 am (Sessions Record)
August 9 10:00:00 am (Sessions Record)
I've researched and used the VL technique, but didn't see an example that matched this. I could do it with 1 Reading record and multiple Sessions records, but not multiple/multiple.
If it is possible, I just don't know where to start. I've considered another TO where all the records reside, basically creating them in the order I need them for the report, but that's more like the VL.
If I want them all to line up it would be easier, or do I just do a VL report, and as I'm appending the records, if they are Session records, just add a tab space?
Just need some pointers.