Notifications
Clear all
Topic starter
Is there a script that can be run in SQL to sign off notes that in Held Status where it says it is signed off a specific user (Like an admin sign off)? Thanks in advance.
Posted : October 3, 2017 8:25 am
If it is a document sent in via some sort of interface, then it might be possible.
If you are referring to an internal note with forms then the answer is no. Signing of a note has a whole lot of behind the scenes actions that it performs. For example, before the note is signed, there is no data in the "docdata" table. There are also form components and document variables stored in multiple tables. All of this gets cleaned up and the data from the documents table is moved to the docdata table.
If you are trying to automate the signing of a bunch of documents made from forms, you are stuck with the GUI.I would recommend looking into AutoIT to control the GUI via key strokes.
Posted : October 6, 2017 3:29 am
