Search Project Mgmt
Search FileMaker Blogs
FileMaker Blog

Thank you for visiting the FileMaker Calculations Explored blog. I recently moved this content over from my blogger account. Hope you like it! When you get a chance, check out the centralized search feature for all the FileMaker blogs found along the right side panel. It is quite handy!

Sunday
Jan132008

FILEMAKER: The Get(RecordOpenCount) Function

From Dwayne Wright
www.dwaynewright.com
info@dwaynewright.com

Get(RecordOpenCount)
FMP Version: FileMaker 8 and higher
Returns A Number Result

This function was introduced with FileMaker 8 and is quite interesting. The Get(RecordOpenCount) function will return a count of the number of open / uncommitted records in the current found set.

Personally, I had troubles getting this function to work for me but I eventually did. I had tried using an unstored calculation field on the layout but that would not work. I tried multiple open windows with unsaved changes. That did not work as well, which bummed me out because I thought this would be a good way to see if multiple unstored record windows could be tracked. So, this function is dependent upon the current foremost open window.

I resorted to using the Data Viewer (a FileMaker Advanced feature). Then I started to get some results. I would modify one record in a portal and the counter would jump to 2. This includes the parent record and the portal record. I updated another portal record and the counter in the Data Viewer went to 3. This means the other portal record change is still open. I worked my way through 5 portal records and the sequence remained true.

Then I did the revert command, the counter quickly went to zero and the changes in my portal records reverted as well.
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Sunday
Jan132008

FILEMAKER: The Get(RecordNumber) Function

From Dwayne Wright
www.dwaynewright.com
info@dwaynewright.com

Get(RecordNumber)
FMP Version: FileMaker 7 and higher
Returns A Number Result

This will return the record number of the current record in the current found set. This number can change dynamically via sorts, deleting records or adding records.

This function is often used in databases that hide the status area in FileMaker. Hiding the status area adds valuable layout space that can be used for fields, buttons and other objects. However, you loose the flip book that FileMaker uses to tell you what record you are on. Using the Get(RecordNumber ) and some other functions, you can effectively design your own customized flip book for your users.

As a side note, this is one of the functions that usually will introduce users to the concept of unstored settings for calculations using the Get function.
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Sunday
Jan132008

FILEMAKER: The Get(RecordModificationCount) Function


From Dwayne Wright
www.dwaynewright.com
info@dwaynewright.com

FMP Version:
FileMaker 7 and Higher

Returns A Number Result

This will return the number of times the current record has been modified and then stored / committed. This can become very handy in FileMaker databases published via the web and in particular in regards to record integrity due to the web being unable to lock a record. In traditional FileMaker use, two users cannot modify the same record at the same time. FileMaker will bark at you and tell you that another user is in a record (thereby locked) and you cannot edit it. With the web interface being a submit method, it is possible for a user to go to a record, the another user modify it and the first users modifications would be on top of the previous one.

So you can query the Get(RecordModification) function to see if there is a gap in the numbering. If so, then you know there may be a multiple user issue you have to contend with.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Sunday
Jan132008

FILEMAKER: The Get(RecordID) Function

From Dwayne Wright
www.dwaynewright.com
info@dwaynewright.com

Get(RecordID)
FMP Version: FileMaker 7 and Higher
Returns A Number Result

This Get function will return the FileMaker created and internally stored record ID for the current record in the foreground window. Since these numbers are internal to FileMaker, they are always sequential, unique and never reused if the record is deleted.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.

Sunday
Jan132008

FILEMAKER: The Get(RecordAccess) Function

From Dwayne Wright
www.dwaynewright.com
info@dwaynewright.com

Get(RecordAccess)
FMP Version: FileMaker 7 and higher
Returns A Number Result

You can define a privilege set to have precise control over what a user can see or do on a record by record basis. For example, you could create a privilege set for sales people to only be able to access records they created. Your privilege set options for record level access are

Create, edit and delete in all tables
Create edit in all tables
View only in all tables
All no access
Custom privileges

The Get(RecordAccess) function will return a number that corresponds to the current users access to the current record in the foreground window. It can be used to alert a user of a restriction or be used as a method to branch a currently running script. The numbers returned from the Get(RecordAccess) functions and their meaning are ...

0 ( zero ) - no access to view or edit the current record

1 - view access to the current record

2 - edit access to the current record

This function is only concerned with the record level setting in the privilege set and does not look at layout access. It is possible to have record access but not layout access ( or vice versa ). In a case like this, you would also want to use the Get(LayoutAccess) function to determine true access for the current record, on the current layout and in the foreground window.

© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.

Page 1 ... 6 7 8 9 10 ... 47 Next 5 Entries »