Hello there.
I know this question is so simple, but how to do retrieve a user id from a field and insert it into another field in the same database.
On Form A my field is called userID.
On Form B the field is called userID_1 field.
I would like to retrieve the value from userID and display it in the userID_1 field.
Thanks
Subject: New to dev - Retrieve Value
using Lotus Sript u can do it.
Subject: New to dev - Retrieve Value
Need more info. How is form B created? Is it from a button on Form A? What is the relationship between the forms? What is the user id? Is it @Name([cn]; @Username) or something they enter themselves?
There are a lot of ways to do things. Without for info on what you are doing, it’s difficult to answer.
Subject: RE: New to dev - Retrieve Value
Hi.
Basically I have used the following formula to generate a user id on form A inside a computed field : -
first:=@Left(@Name( [CN]; @UserName) ; 1);
last:=@Right(@Name( [CN]; @UserName) ; " ");
last2:=@Left(last ; 1);
year:=@Text(@Year(@Now));
month:=@Text(@Month(@Now));
day:=@Text(@Day(@Now));
hour:=@Text(@Hour(@Now));
minute:=@Text(@Minute(@Now));
second:=@Text(@Second(@Now));
“[”+@Text(first)+@Text(last2)+@Right(year;2)+month+day+hour+minute+second+“]”
Then I have included a button on form A that will open form B up. On form B, I have created a field that is computed and basically whatever ID is generated from the above formula…I would like to display in the computed field of form B.
Thanks,
M
Subject: RE: New to dev - Retrieve Value
Look at @updatedocumentcontext - that is what you want.
Subject: RE: New to dev - Retrieve Value
Hi,
Thanks for your response.
I cant seem to find anything on “@updatedocumentcontext”. Is it called something else?
Thanks,
M