There’s a status field that is set to reviewed once an approver clicks a button. How can I manually modify this field since the process is not working. Would I have to add an editable field?
thanks
Subject: How to modify a database field
Hi Phil,
Create a agent, simple Actions, Target–> All selected documents, Add Action.
There you can see the option append/replace select the field and give the value what ever you want. run the agent manually from the view mode.
I hope this helps.
cheers
RAJ
Subject: RE: How to modify a database field
It works. One of the fields is Date what would I type for sysdate, it won’t take “Nov 14, 2007”
Subject: RE: How to modify a database field
Hi Phil,
If it is a date field then you have to convert the string to date and then you have to format the date(dd\mm\yy,mm\dd\yy) according to your requirement.
i dont know how to format using formulas here you have to use script.
EX: Format(Datevalue(“10-18-14”), “d,mmm,yyyy”)
cheers
raj
Subject: How to modify a database field
No, just add an action or agent that sets a new field value. This can be done from the document or view level.
FIELD YourFieldName := “Desired Value”
will set that item regardless of form logic, if you have sufficient access rights to edit this document.
If you want something really handy to change item values, have a look at Chad Smiley’s great “Edit Document Fields”:
http://www.chadsmiley.com/chadsmiley/home.nsf/htdocs/Edit_Document_Fields_History