Have a large number of docuemnts is there a way of updating the planned date field to a certain value which is the same value without manually for a number of documents. Do not have access to the Sql server or server.
grateful for any tips
regards
Natahsa
Hi Natasha,
It is not possible to update the date for large no of Documents by using eB. It can be done by SQL but that will be done by Professional Services Team.
Regards,
Sayyad
Answer Verified By: natasha chetwood
Hi Sayyad, thanks for that
however I have a list of documents that needs planned date set to a constant i.e 30/10/19 is there a way of like
writing a vba script like sendkeys "30/09/19" for each of the documents
i.e have an array of document reference and a script that activates the document by the reference number then
activate the edit button of the document then setfocus o the planned date field then Senkeys of "30/09/19" ????
If you are using VBA , it will also need the credentials of Database for connection. Again it will go to SQL only. So, the best way will be making changes in SQL only, but these changes are done by PS Team because of the risk in handling database.
Hi Sayyad
ok thanks