hello users

can someone assist me in with the following problem.

I need to notify a person when a record is entered in the database any ideas

Thanks

D

Hi D,

Script the creation of new records aand add a 'send mail' script step to that same script.

Ernst.

Thanks for responding Ernst. The script works fine but it impedes the radio button action. You cannot select because the tranparent button is in the way. Anyway I can get around it.

Don

Don,

If from your button you need to set a field (like where your button is placed over a radio button field) you can add to your script after the new record/request call

Set Field [Your Radio Button Field, "The value list item(s) to be turned on"]

Thanks but Andy I cannot get it to work

Don

What does not work?

I don't understand the "set field" script. It is probably me that does not make it work

D

If radio is your field and you want to have 'a' and 'b' selected, then Set Field[radio, "a

Or check for "a" or "b" with If and switch them around.

Since we're talking about a script to trigger a radio button field - and radio buttons are generally used as an 'either/or' (but not both) phenomenon, Queue's suggestion of setting the field to "a

Thank you,

The notification comes up now however the message "field not modifiable" also is displayed and will not let me select the radio button.

At least now I am half way there can you elaborate further?

Don

If the 'Field not modifiable' error dialog appears when you click on one of the script buttons - assuming your scripts are along the lines outlined in my previous post, that would relate to the radio button field.

Is your radio button field a calculation field by any chance? If so that would account for it not accepting a value.

no it is just a simple text field radio box value. one choice is regular student the other is special student. When the special student box in enabled it should send a message to the special ed dept.

the message works but i cannot select the special student radio button.

i made the button transparent as outlined in your post.

thanks for spending so much time on this

Don

If SpecialStudentBox is a modifiable text field and your script has a step along the lines of:

Set Field ["SpecialStudentBox", "Special"]

and when you run the script you are getting an error message and the value in the SpecialStudentBox field is not changing, then the most likely causes are:

1. Your Set Field script step is targetting the wrong field, or

2. Your button is attached to the wrong script.

If neither of those things appears to be the case, then there must be something else going on that you've not mentioned so far on this thread. In which case, I suspect that you might be best to make a copy of your file with a single record in it and post it as an attachment so that we can have a look at it for you and tell you what is causing the problem.

maybe i am not doing the transparent button properly. can you tell me the procedure for making a button transparent

Don

Yes.

1. Go into Layout mode

2. Make sure the status area (the panel at the left of the screen) is showing

3. click on the button object to select it

4. click on the fill pattern pallette on the status area (use the middle one of the three buttons side by side immediately above the paint bucket symbol on the status area) and select the top left fill option which has a symbol which looks like two empty boxes overlapping.

5. do the same using the line pattern pallette (the middle one of the three buttons immediately above the pen symbol a little further down on the status area).

When you have done the above, the button should remain selected (the four selection 'handles' at its corners whould still be visible, but the button itself should not). When you click elsewhere in the layout to de-select the button you should no longer be able to see it at all.

Once an object such as a button has been made invisible, it is difficult to tell it is there unless you select it - which can be done by dragging a rectangle around the screen area in which it is located - whereupon the selection 'handles' will reappear.