Hi everyone, I am new to lotusscript. Hope to get some help from here since I couldn’t find the related topic shown as below:
Statement:
Now I have a field in the form which requires user to input a value into that field. For example, a user has keyed in a DATE into the field.
Problem:
How do I save that DATE value into all entries in a database by just ONE time saving, instead of saving the same date for all entry in a particular database manually?
Thank you in advanced!
Subject: Simple formula agent will do it
Create an agent where the target is “All documents in database” with a formula like that shown below:
FIELD SomeDateField := [05/06/2010];
SELECT @All
then run it from the Actions menu. No LotusScript required.
Subject: Replacing [05/06/2010] by a ‘not fixed value’
Thank you so much! I have created an agent triggered by an action button. It works!
However, i have a new problem dealing with the code. Based on the given code:
FIELD SomeDateField := [05/06/2010];
SELECT @All
The [05/06/2010] has to be changed to a value that is not fixed to a particular date. The user can actually input any date that they want in the program.
In my case, I have created another FIELD called as “expiryDate”. This field allows the users to key in the date based on their preference. So I have modified the code to:
FIELD SomeDateField := expiryDate;
SELECT @All
And it appears nothing in the saved result. Is there any way for the ‘view’ to be able to read the value in the “expiryDate” field value?