February 21, 200817 yr I have one layout that contains job information. There's one field named Status. The Status can either be 'not approved' or 'approved' . If the status is not approved I need the users to see only a few fields, when the status becomes approved, I'd like them to see more fields. What I did is designing 2 tabs one for not approved and one for approved and using ZippScript I made a script that goes to the right tab when you change the value in the Status field. All works well until you navigate to the next record. At that point the default tab kicks in whether the status is approved or not... Should I change my approach to the problem? Any suggestions? Thanks!
February 21, 200817 yr You may want to look into these although I do try and stay away from EventTriggers: http://www.zipptools.com/ http://www.fmforums.com/forum/showtopic.php?tid/193376
February 21, 200817 yr Create a new field in the table, a calculation field with a text result = "Approved". Creae a TO of the same table and relate the two primary keys together (a self join). To that relationship criterion add cApproved = Status. Put a large one row portal on the layout showing the extra fields. They'll only be visible when the status is "Approved".
February 21, 200817 yr Author mr_vodka: Why do try to stay away from event triggers? Edited February 21, 200817 yr by Guest
February 21, 200817 yr You can trigger a script when changing records, by putting the trigger calc in custom record access privileges.
February 21, 200817 yr I am not saying that I do not use them but sparingly since they are not native to FM. Furthermore, if not properly done it can cause headaches from a management standpoint.
Create an account or sign in to comment