Can a Unsorted Calculation Field be saved into Another Field without Scripting, It seems I can not save that Valve another Field just using Calculation Functions (=$$XXX), and several other common "WorkArounds" within the same Record.
When that first record is saved the next record will contain the Previous Global Field, not the Current. The Field accepting the value of the Unsorted Calculation on the Current Layout doesn't accept a Refreshing Global Value on the Layout.
I have written a Calculation using a "Let" function and have Defined a Global Variable, "$$Original" for a Container that Contains an Image. Basically an Image is placed in a Container Field. That Container Field saves the Original Image name into a Global Field before renaming the Image. That Original Image name should be saved into that record for future Reference.
I am able to view the Original Image name on the Layout, using Merge "<<$$Original>>" and also within another Field that is Unsorted, "Do Not Store Calculation Results - Recalculate when needed". These Two Fields Update each time a new Image is placed into the Container. Of Course these are "Global" and I would like to have the Result save local to the Record after Committing Record to Save
Keep in mind I would like to do this all via Calculations, not Scripting.
I realize that "Set Field" and "Replace Field" in a Script does work. The other workaround technique, to Refresh, using a combining a Global Field with another blank Field, or an IF statement, will not work in this case.
So, sorry if I'm Confusing. I've tried what I thought was a lot of different options and tests, and tried to read as much on topic as possible. Not seeing the Solution to this issue, or work around.