To return a value that uniquely and permanently identifies a record in this table, use getrecordid. For future reference, the way to do this is as follows. Under specify, select the table which contains the related record you want to go to. I can get the record id using get recordid, but i cant seem to use this number to return to a record later. Get uuidnumber, introduced in filemaker pro 17 advanced, returns a number representing a large universally unique identifier uuid value.
Go to record requestpage does indeed want a record number it moves the focus forward or backward through your record set. This allows the script to be completely context free. Rightclick on the portal row and click button setup. In either case, the the delete recordrequest script step deletes the current record. When using get uuidnumber, filemaker pro advanced will return a unique, 24byte 192bit number. It sounds like what you want is to jump to related records based upon a unique key field. There are many other new design enhancements in filemaker pro 12, and one of my favorites is the option delineate fields on current record only in the layout setup dialog. You can read his full explanation over at modular filemaker. Select the layout that you would like to display the related record. The name of the network protocol that filemaker pro is using on this. Get field contents from clicked portal row filemaker pro. I am using the php api to insert records in filemaker. Returns a number representing a records position in the current found set.
To return a value that uniquely and permanently identifies a record in this table, use the getrecordid function. In short he suggested using filemakers built in record id instead of the primary. We would like to show you a description here but the site wont allow us. The record id get scriptparameter didnt work for me, that was the first thing i tried since its the easiest. Not to drag up an old thread from the dead, and ask a similar question, butwell, yeah, to do that. Returns the number of the current record in the current found set. Go to record number goes to the record with the position in the current sort order corresponding to number. Returns the unique id number of the current record. For example, you can use this function to generate a unique id of a record. And a recordid is always unique to each record in a table. In an unsorted state, the internal record id values are always in order from lowest to highest. Custom function to get the list of ids from the current found set. Working with records script steps from filemaker pro 8. You can get only so far with your scripts by working with field values.
Continue this pattern, splitting the remaining records in half in each iteration until we arrive at the correct record. Go to record via record id script workspace and script. Get the latest software updates and resources for the filemaker platform. Now suppose this database includes an orders table with an order id field. How do i retrieve the record id of a newly created record in php api. Filemaker pro is simply a powerful software used to create custom. If data is selected in the active field, filemaker pro searches for the selected data. I have written one custom function to get the list of product ids from the current found set. Returns a number representing the record that has focus in the current found set. The number returned is a decimal value an integer generated by filemaker pro when the record is created. Download filemaker updates and resources filemaker. You can use any field which you want from your current found set. A number representing the current multiuser state of the database file.