If you want to reverse the top to bottom order shown, you simply need to reverse the left to right order of terms in your set field step's calculated result.
But a portal sorted to put the entries in the order desired with a script that simply creates a new record each time you need a new note is much simpler and provides opportunities for working with the data that is really practical when you put all of the data into one field.
Currently, I am just testing my script. If I feel I need to have extra note filed, I will create one. Thank you for the tip!
But I am not quite understand what you mean by "reverse the left to right order of terms", could you please be so kind to explain it. And sorry for the trouble!!!
in your set field script step swap it that the calc looks like: "Previous.. " & $$Exisiting & ... & Inventory::Note for Price..
Please note that I did not recommend adding an extra note field but rather that you add a related table.
In in one of our systems I am in the process of phasing out just such a single, multiple entry note field as the single note field quickly becomes difficult for the user to work with.
is empty( Old data ) ; New data;
Old data & "¶" & New data
Or even simpler:
List ( old data ; new data )
If there is no old data, this function will not put a return where it isn't needed.
Sent from my iPhone