Hi. I'm using FMPro 12 Advanced.
Creating a database for our community centre and I need to add a membership number to contacts - but not all of them.
I've created a separate table for Membership numbers (as not all contacts will have one, so serial numbers aren't appropriate).
Each membership has a number of details fields.
It's probably a REALLY logical and stupid problem I'm batting against - but I need to:
Select a contact>go to their details>add a membership number (go to a floating window layout, enter the details to the serial-number-derived membership) and have the details including the number show up in a tab on the contact's details layout.
I've created a relationship between my contacts file and my membership file via the Contact_ID>Contact_ID_fk and have played around with other relationships.
I've also created a simple script from a button on the Contacts membership tab to go to the Membership Layout window and create a new record. But it keeps creating a new record in the Contacts, not Membership - even though the relationship only has to create new records in the memberships side.
I'm now running around in circles - please can anyone help me out here?????
I have a weird issue that just started happening when I use the 'Print to PDF' script step in a loop.
I have a script that passes through and prints out a set of pages. When I use the script Debugger and when I reach the spot I am having issues with, I can see, during the preview, that it is in the correct record; showing the correct page, but once it is done and saved as a PDF, it is showing the first record that was browsed.
I have attached a snapshot of the script I am using.
If you notice, I have it go to the layout First, Performs a Find based on a Variable - It finds the proper records.
Then it goes to the first record, (for this example, lets say record # 36)
Starts a loop and saves the record being browsed to a PDF. Then it moves on to the next record in the found set.
The Custom Dialog which SHOULD show the next records ID, does not. It still shows record #36.
I have no clue as to why. Even though as I go through each script step and I can visually confirm it is moving to the proper record in the FileMaker client, it does NOT save the proper Record.
If I switch the option on the 'Save Record as PDF' from Current Record, to records being browsed, it saves the proper records to PDFs, but it duplicates them 3 times and does not set the proper page numbers.
Attached is also the end result
The Observ ID: should be 36, 37, 38 but all three pages stay at 36 showing the exact same record.
Thank you all for your help.
I have a number of scripts that have worked perfectly for years in previous versions of FileMaker, however in FMP 15 they causse FM to crash. They only way I have found to avoid the crash is to use the debugger and to use the "step into" button. That of course is a very cumbersome workaround. You can see one of the culprits below. Anyone have any ideas what's wrong here?
We have a web based tickets portal which creates new messages in our filemaker database - this is for customers' use. It does this using the PHP API (the website was developed by a third party). We would like the owners of tickets to be notified when the customer has added a message to one of the tickets that they are in charge of.
Is there a way for filemaker/filemaker server to trigger a 'send email' script when a new record is created via the web portal? Or would it be simpler for this action to occur on the web side?
I have more than 10k executable files, each EXE export data to a single table, inside of an unique MySQL.
I created a FM database to manage all data (ODBC), but I didn’t solve how to trigger a script from an external EXE, without looping for new data each minute.
#01: There is way to trigger a script in an open database, without looping ?
#02: Runtime solutions can be used with parameters?
My best idea, at this time, is to create a runtime solution and a relationship, and call it from the EXE. I do think is a "stupid idea" and there must be clever solutions out there.
Thanks for all
INFO: I am using windows 10 | FM Pro 15