My client has a Contract database. I use UUID for primary keys, however, I have an auto-enter serial to display the Contract ID on the form.
Client wants to enter last year's Contracts that were created before FileMaker. So, I opened up the serial field to allow edit (but maintain Unique validation). It's getting messy. As they enter old contracts, they are overwriting the next serial id. Of course, they now have gaps...with which they are not happy.
Suggestions for a better approach? Script the Contract ID using a max +1 calc (perhaps using ESQL to obtain that value?).
I made a 1 Mb filemaker abc.fmp12 file which I want to sell.
User may download filemaker GO 12 from AppStore.
I send the file to user by email. But it should work on only 1 IPAD (in windows it was possible with HDD serial number look plugin).
Any ideas ? how to make my software copy protected ?
Do FileMaker can look iPads Serial Number?
I have made three tables: Meetings, People, and a People-Meeting join-table. I need to create a button in the Meetings table that brings me to the People-Meeting table, create new record, and then autofill the last serial number from Meetings into the Meetings ID field of the newly created record in the People-Meeting table.
I've only managed to make a script as follows:
Go to Layout ["People Meetings"]
Go to Field ["People Meetings::Meeting ID]
But I don't know how to do the autofill part. Can anyone help please?