I Have this formula in an editable field in the input translation. I have the form to Automatically Refresh fields. The problem is that this field will not populate unless I click in the field. It will not populate when the form is saved or if I hit F9 Refresh. I thought this is how input translation is suppose to work.
increment:= @If(@Weekday(CurrentTarget) = 6; 12 ; 12);
Thirtydays :=@Adjust(CurrentTarget; 0; 0; 31; 0; 0; 0);
@Adjust(Thirtydays ; 0; 0 ; increment; 0; 0; 0)
Subject: Input Translation is used when doc being saved
Default formula is used for refresh. So you need a Default formula.
Subject: Default Formula
The user enters a target date after opening the form so I need it to calculate a date using the input translation.
Subject: Are you sure you don’t need a computed field?
An input translation assumes the user can edit the field. So, if you are computing the value based on another field, than the user can still change the value. BUT, when the user saves the document than whatever the user entered will get overridden.
I think what you want is a computed field.
Howard
Subject: *and also are computed when refreshed (F9)
Subject: What is currenttarget?
Is currenttarget another field on the same form? Is this something the user enters a value into? Make sure you are getting a value for this. Use an @Prompt as a debug tool to verify.
Howard
Subject: CurrentTarget Value
Yes, this is a field on the form. It has a value in it when it is closed and saved. If I click in the field it will populate.
Subject: Solved
the first refresh (or save) was populating the CurrentTarget field. The other fields needed the data in the current target to calculate. I entered an @Command(file save) when they entered the target date. This populated the CurrentTarge field. Then when they closed the document it saved (refreshed) again this populated the other fields using the CurrentTarget Date. Thank you for making me look at the CurrentTarget Field a little closer!