RET Posted January 30, 2002 Posted January 30, 2002 I am new to scriptmaking and I want to create a script that will change a field with a radio button, from "Yes", to "No". then I would like to create a button that will perfom the script when pressed. I guessing this might me pretty easy, but I'm having trouble. Can anyone help? RET
The Bridge Posted January 30, 2002 Posted January 30, 2002 One script step should do it: Set Field [Fieldname, "Case(Fieldname="Yes", "No", "Yes")]
RET Posted January 30, 2002 Author Posted January 30, 2002 Thanks so much.....that relly worked. however I guess I was not too clear. I wanted to preform this script to all records, can you help me do that? RET
Korky Posted January 30, 2002 Posted January 30, 2002 Use the 'Replace' Script Step'along with the formula already given
The Bridge Posted January 30, 2002 Posted January 30, 2002 quote: Originally posted by Korky: Use the 'Replace' Script Step'along with the formula already given Applying the given calculation to multiple records will actually toggle the field value, i.e. will change Yes to No and No to Yes. If you just want to change Yes to No and keep No as-is, then use the following: Set Field [Fieldname, "Case(Fieldname="Yes", "No", Fieldname)"] An alternative to the Replace command would be to loop through the found set and use Set Field. This way you can perform a Find for all records where Fieldname=Yes, just to make sure. Oh, the possibilities.
RET Posted January 30, 2002 Author Posted January 30, 2002 thanks guys...that worked. one more thing .....is their a good book to learn more about scripts?
Recommended Posts
This topic is 8337 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