0

Issue with ID

Let me better explain:

I have created a formula formula to order my price quotation that goes like: “AR” + ID + “” + yearmonth(today()) + “D” (result this month:AR12020/11D).

 

The issue is that 11 stands for november, but in december it will be the same “record” but changed in AR12020/12D and this is bad. I want to lock it. Is there any way to do that?

1 reply

null
    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Well, a fomula field is always recalculated, I think you better use a text field to hold the data and populate this field with a trigger on create or a button to do so.

    Steven