a) @@
b) ##
c) ^^
d) //
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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, August 30, 2009
Saturday, August 29, 2009
Which of the following is NOT an option in the Portal Setup dialog box?
a) Allow deletion of portal records
b) Show [ enter number here ] number of portal rows
c) Show horizontal scrollbar
d) Alternate background with
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
b) Show [ enter number here ] number of portal rows
c) Show horizontal scrollbar
d) Alternate background with
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
Thursday, August 20, 2009
Portals have ...
a) Calculation Capabilities
b) Filtering Capabilities
c) Both A and B
d) Neither A or B
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
b) Filtering Capabilities
c) Both A and B
d) Neither A or B
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
Wednesday, August 19, 2009
As of FileMaker 10, which is NOT a part of the define portal dialog box?
a) Sort Portal By
b) Allow Deletion Of Portal Row
c) Show Vertical Scroll Bar
d) All Of The Above Are Available
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
b) Allow Deletion Of Portal Row
c) Show Vertical Scroll Bar
d) All Of The Above Are Available
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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, August 16, 2009
FILEMAKER: OnObjectEnter Script Triggers And Portals
From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
APPENDIX 2: Portal Misc
The OnObjectEnter script trigger will fire when the layout object it has been applied to becomes active, most likely by a mouse click, keyboard tab action, scripted action or if that field is first in the tab order when a new record or new find request is created.
A portal is a layout object and is also one of the few layout objects that can contain multiple layout objects. That is to say the portal can have objects within it (such as fields) and the instance count of those objects goes up with every related record that portal displays. Doing the math, a field with the OnObjectEnter trigger within a portal row can be displayed 6 times, one for each related record. So that one trigger becomes six triggers in browse mode.
Now lets recap, you can have an OnObjectEnter trigger applied to a portal, objects within the portal or both. The OnObjectEnter trigger assigned to a portal will fire whenever a different row in the portal becomes active. Objects within a portal are repeated for every related record they display and those objects can have the OnObjectEnter trigger applied to them.
What happens when a user clicks into a portal row field and both field and portal have an OnObjectEnter trigger assigned? The OnObjectEnter trigger assigned to the portal will fire first and the field OnObjectEnter trigger will fire second.
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit http://www.dwaynewright.com/donate.html
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
APPENDIX 2: Portal Misc
The OnObjectEnter script trigger will fire when the layout object it has been applied to becomes active, most likely by a mouse click, keyboard tab action, scripted action or if that field is first in the tab order when a new record or new find request is created.
A portal is a layout object and is also one of the few layout objects that can contain multiple layout objects. That is to say the portal can have objects within it (such as fields) and the instance count of those objects goes up with every related record that portal displays. Doing the math, a field with the OnObjectEnter trigger within a portal row can be displayed 6 times, one for each related record. So that one trigger becomes six triggers in browse mode.Now lets recap, you can have an OnObjectEnter trigger applied to a portal, objects within the portal or both. The OnObjectEnter trigger assigned to a portal will fire whenever a different row in the portal becomes active. Objects within a portal are repeated for every related record they display and those objects can have the OnObjectEnter trigger applied to them.
What happens when a user clicks into a portal row field and both field and portal have an OnObjectEnter trigger assigned? The OnObjectEnter trigger assigned to the portal will fire first and the field OnObjectEnter trigger will fire second.
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit http://www.dwaynewright.com/donate.html
Friday, August 14, 2009
What setting needs to be in place for direct (non scripted) portal row deleting?
a) “Allow Record Deletion Via Portal” In Relationship Setup Dialog Box
b) “Allow Deletion Of Records” In Portal Setup Dialog Box
c) “Allow Record Deletion Via Portal” In Layout Setup Dialog Box
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
b) “Allow Deletion Of Records” In Portal Setup Dialog Box
c) “Allow Record Deletion Via Portal” In Layout Setup Dialog Box
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
Thursday, August 13, 2009
A requirement of being able to successfully perform a find with a portal would be a stored parent key.
a) You cannot do finds with portals period, the parent key doesn’t mean anything
b) Yes, the parent key needs to be a stored value to perform searches with a portal
c) Stored or unstored, you can perform successful portal searches
d) False, portal searches can only be done if the parent key is an unstored value
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
b) Yes, the parent key needs to be a stored value to perform searches with a portal
c) Stored or unstored, you can perform successful portal searches
d) False, portal searches can only be done if the parent key is an unstored value
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
Wednesday, August 12, 2009
A READER ASKS: Last Row Isn’t A New One
From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
APPENDIX 1: A Reader Asks
A READER ASKS
In my own solution I set up the relation between two tables without allowing the creation of records in the child table. Via a script I make a new record. The problem I encounter is that the script step 'Go to portal row - last' selects the last row, but I want it to select a new row where I can fill in the new data.
I hope you understand my problem and perhaps you can give me a clue to solve it.
-------
DWAYNE RESPONDS
You cannot create new records via a portal without having the “allow the creation of new records” option active in the relationship. So if you create a new record via a script, you will need to make sure the related record has the primary key data. So the script will likely ...
- put the parent records primary key field data into a variable
- go to the related table layout and create the new record
- set the foreign key data using the variable / commit the record
- go back to the parent table (possibly refresh the screen)
- go to the last portal row and the appropriate field for data entry
- enter in the new data
NOTE: If the relationship or the portal has sorting in place, the target row may not be the last portal. Chances are that it is either the first row or the last one. You will want to make sure and perform a number of tests.
Now if the problem persists, here are some possible culprits ...
- the key id from the parent table isn't coming over properly
- the fields in the portal are not from the same relationship as the portal
- the fields behavior setting does not allow you to click into the field
- the fields security settings do not allow editing
- the foreign key field cannot accept new data (calculation field)
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit http://www.dwaynewright.com/donate.html
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
APPENDIX 1: A Reader Asks
A READER ASKS
In my own solution I set up the relation between two tables without allowing the creation of records in the child table. Via a script I make a new record. The problem I encounter is that the script step 'Go to portal row - last' selects the last row, but I want it to select a new row where I can fill in the new data.
I hope you understand my problem and perhaps you can give me a clue to solve it.
-------
DWAYNE RESPONDS
You cannot create new records via a portal without having the “allow the creation of new records” option active in the relationship. So if you create a new record via a script, you will need to make sure the related record has the primary key data. So the script will likely ...
- put the parent records primary key field data into a variable
- go to the related table layout and create the new record
- set the foreign key data using the variable / commit the record
- go back to the parent table (possibly refresh the screen)
- go to the last portal row and the appropriate field for data entry
- enter in the new data
NOTE: If the relationship or the portal has sorting in place, the target row may not be the last portal. Chances are that it is either the first row or the last one. You will want to make sure and perform a number of tests.
Now if the problem persists, here are some possible culprits ...
- the key id from the parent table isn't coming over properly
- the fields in the portal are not from the same relationship as the portal
- the fields behavior setting does not allow you to click into the field
- the fields security settings do not allow editing
- the foreign key field cannot accept new data (calculation field)
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit http://www.dwaynewright.com/donate.html
Sunday, August 9, 2009
When a user clicks into a portal row, the parent and child records are _______.
a) Opened
b) Refreshed
c) Highlighted
d) Locked
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
b) Refreshed
c) Highlighted
d) Locked
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
Thursday, August 6, 2009
To create related records in browse mode via a portal, the _______ needs to be setup properly.
a) Portal Scroll Bar
b) Portal Fields
c) Portal Buttons
d) Portals Relationship
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
b) Portal Fields
c) Portal Buttons
d) Portals Relationship
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
Wednesday, August 5, 2009
Having a relationship being sorted can ______ your system down under extreme conditions.
a) Crash
b) Speed Up
c) Slow Down
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
b) Speed Up
c) Slow Down
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
Tuesday, August 4, 2009
_______ background is a portal setup option to create a visual indicator between portal rows.
a) Highlight
b) Alternate
c) Focus
d) Indicate
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
b) Alternate
c) Focus
d) Indicate
=====================
TO SEE THE ANSWER TO THIS QUIZ QUESTION
(CLICK HERE)
=====================
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.
© 2009 - 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.
Subscribe to:
Posts (Atom)
Posts
