Button Script

[Sooner Shadow]

I have a button that, when clicked, it finds a record based on the contents of the "names" field. If that record exists, it goes to that record and the script ends there. If that record does not exist, I would like it to then create a new record. I would like this all to be done with the one click of the button. I am an extreme novice and any help would be greatly appreciated.

Thank you!

[LaRetta]

You can try this:

Enter Find Mode [pause ]

Set Variable [ $name; Value:table::clientName ]

Set Error Capture [ On ]

Perform Find [ ]

If [ not Get ( FoundCount ) ]

New Record/Request

Set Field [ table::clientName; $name ]

End If

This allows the User to perform a regular find on the name, stores that request into a variable, performs the find and, if it can't find that name, creates a new record. I would suggest asking the User to verify if they want a new record. I would also caution that if something is misspelled, you can get same customer added twice.

It might work better to include something truly unique about them, such as phone number.

[Sooner Shadow]

I'll give it a try. Thanks.

You can try this:

Enter Find Mode [pause ]

Set Variable [ $name; Value:table::clientName ]

Set Error Capture [ On ]

Perform Find [ ]

If [ not Get ( FoundCount ) ]

New Record/Request

Set Field [ table::clientName; $name ]

End If

This allows the User to perform a regular find on the name, stores that request into a variable, performs the find and, if it can't find that name, creates a new record. I would suggest asking the User to verify if they want a new record. I would also caution that if something is misspelled, you can get same customer added twice.

It might work better to include something truly unique about them, such as phone number.