igotit Posted November 7, 2007 Posted November 7, 2007 I have a script that runs to check fields to make sure that everything has been updated. If everything is correct after the script runs. I’d like an invisible button to become visible that the user can click on for the next step. Thanks for your help, Milo
sbg2 Posted November 7, 2007 Posted November 7, 2007 http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000743
igotit Posted November 8, 2007 Author Posted November 8, 2007 Hi sbg2, I thought with FMP 9 there is another more straightforward way of doing this. Do you know what I mean or am I just out there somewhere? Milo
mdpres Posted November 8, 2007 Posted November 8, 2007 (edited) Just a quick thought. How about: IsEmpty(yourfield) set fill color to your background color set text color to your background color Then if the field has a value it would show up. Hope that gives you something to work with. Dean Edited November 8, 2007 by Guest
sbg2 Posted November 8, 2007 Posted November 8, 2007 I have only played around with the Version 9 trial... but as far as I know they haven't added this feature. I see you can change the Fill Color or Text color but could not change the line color or the edge formatting (Engraved, Embossed etc.). Plus the button will still highlight when clicked on. If you can live with the Black Highlighting simply MyContainerCalc = If(This Condition; MyButtonGraphic) would work better than changing the Text color and fill color IMO.
The Big Bear Posted November 9, 2007 Posted November 9, 2007 (edited) igotit This can be done with a portal. Add these two fileds to your table. They do not have to be on the table layout itself. constant calculation = 1 Condcalc calculation = case( IsEmply(the field that state that everything has been completed);"";1) Create a self join relationship using these two fields. condcalc = constant Make a portal with this relationship. Use the same baack ground on the table layout that you want to display the buttom. install your button into the portal. add this to your script that checks to see if all fileds are completed. If[relation name: field = 1] set field [ your field ; ""] else set field [ your field; 1] end if What this does is when constant is your field are both equal to 1 then the button is visible. When your field is is empty then the button is not visible. I have attached a file. Lionel button.zip Edited November 9, 2007 by Guest
FestiveEmbalmer Posted November 9, 2007 Posted November 9, 2007 That is much better than conditional formatting because the button isn't just invisible, it isn't even there unless the relationship is valid.
igotit Posted November 12, 2007 Author Posted November 12, 2007 Hi Lionel, That works great and I thank you for the information and expecially the file. That really helped me to understnad it. I've found I have one problem. Where I'm using this the files are checked for "Must Entry" fields. Any fields that are left blank have *************** inserteded into them. Your script picks that up as a finished field and shows the portal. One other problem is one of the fields holds a "math test" like 5+2= and you must enter 7 to continue. I'm sure if someone enters the wrong number, again the portal will be shown. Is there a way around this or do I need to come up with another way of doing this? Milo
The Big Bear Posted November 14, 2007 Posted November 14, 2007 Milo Since I do not know how you are checking the fields for completion and inserting the *****, I can only make the suggestion that you run the supplied script first to check for empty fields before entering the **** into an empty field. As for the math question, please see the attached file. button2.zip
Recommended Posts
This topic is 6220 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now