Page 1 of 1

Resetting ok to Text Field

Posted: Fri Jul 20, 2018 6:08 am
by drtech
I would like reset the "Text OK" field back to "??" for all patients who are currently marked "YES", but leave all the pts who are marked "NO" the same. We are revamping our permissions with better written authorizations, so I need everyone back to square one unless they already told us no texting. Can we get a simple query to do this?

Thanks

Re: Resetting ok to Text Field

Posted: Fri Jul 20, 2018 9:02 am
by jsalmon
Open Dental doesn't give out queries that manipulate data. All data manipulation should be within the program for security purposes. Therefore a feature request would be required for a tool within the software to do it.
http://www.opendental.com/manual/featurerequests.html

Re: Resetting ok to Text Field

Posted: Fri Jul 20, 2018 11:54 am
by drtech
ok, thanks, I will try to write one since I can't put in requests.

Re: Resetting ok to Text Field

Posted: Thu Jul 26, 2018 8:58 am
by drtech
it is simple if someone needs to do something like this:

************NOTICE, THIS WILL ALTER YOUR DATABASE*****************************

Text deleted by admin.
Reason:
Open Dental doesn't give out queries that manipulate data. All data manipulation should be within the program for security purposes.

*********************************************************************************************