Start with date in a multi line test field
Good evening and greetings to all. I need that every time I enter a new text in a multi line text field, it automatically inserts the date before I start writing. Can someone tell me how to do? Thank you.
Hi, Kruna, thanks
I have done what you tell me but it doesn't work for me.
I have done what you have told me and I have put the formula in the table trigger, but it deletes the text written by me.
I have a table called 'Notes' and a text field called 'Comments'
I want that if I write a comment today, today's date appears and tomorrow when
I write another comment I insert tomorrow's date keeping the previous comment and
yesterday's date and so on.
All this in the same registry.
I do not know what I'm doing wrong.
I'm new to Ninox, excuse me
You can try something like:
In the Trigger on new record:
Comments := today() + " "
For me if I just do:
Comments := today()
It puts in the milliseconds so I added the carriage return at the end and it treats it as text. It might work for you with the carriage return if you use the Cloud version.
I don't know if you want a date in Comments whenever you create a record. You can decide on that.
Then in the Trigger after update you can try:
if contains(Comments, text(today())) then null else Comments := Comments + " " + today() end
I start by looking to see if the current date has already been entered and if it has then I won't do anything to the Comments field. If I can't find today's date then I will add today's date. With out the check then anytime you make an update to the record it will log today's date.
Another way is to create a Comments child table and create a new record for each new day. So you can have as many or as few comments per Note record as you want.
Hi Kruna and Fred, Thank you very much for your interest. I've tried what you suggest, Fred, and I can't get it to work. I am sending you a screenshot of what I really want to do. I think I have not been able to explain myself clearly, please excuse me. It is a field of a record that I would update when needed, adding comments on different dates. Thank you very much again