How to update automatically "Trigger after update" option of a field?

Hi Alain,

Thank you for your answer. I didn't know the "Trigger after open" option, it could work but, I have too many fields to execute and with too many conditions each time for the same Selection field.

This will generate too many lines of code in condition knowing, that new fields can be created or old ones changed and it will become too complicated to modify
Isn't there a "simpler" solution that can be applied directly to each "Trigger after update"? As a lure to the program that thinks the field has been changed/updated and then it triggers its own "Trigger after update"?
I hope I am clear enough in my explanations. Because the example I gave before was just a simplified example. You have to carry this over to several dozens of fields which, depending on their result in relation to time, will modify a selection field with about 8 types of status.

Hi RoSoft_Steven Rooryck,

It's what I thought and tried, but a error message says me that it's not possible to modify the data (the code is a little bit the same than above, it works in the trigger field but in the formula field no...)
I really don't know how to do...

Hi John Hall, thank you for your response !

But I don't quite understand what you mean.
Of course I can create a formula field which, depending on this or that event, sends me such and such a message as "Late". I have already done this in particular so that the user enters the information correctly (for example, a message saying that the return date of the email cannot occur before the sending date)

But I really need a selection field with different status to be impacted by a time bound "trigger". Since depending on its value, I then collect it in a dashboard to differentiate the different progress of my file.
And this state depends on the time between that of my consultation at the time, and the last updated field (if I fill this field today, I want in 15 days, its progress state to change for example from "In treatment "to" Make a follow-up ").

Hello John Hall,

I think I will explain part of what I want to do with the concrete example of my database and tables.

I have created a table called "File" containing all the information related to the files of my work office, and inside this table, a sub-table called "Connection request" containing a request sent to a network concessionaire which can be electric, gas, drinking water, rainwater, wastewater, etc.

A file can contain several connection requests, each one different depending on the concessionaire . But a connection request cannot be referenced to several files (hence the idea of the sub-table).

And if you want, the purpose of my sub-table "Connection request" is to allow a follow-up of these over time according to whether or not such or such step has been executed. So, I have several date fields corresponding to different actions, like for example, the date of sending the connection request to the concessionaire, another field corresponding to the acknowledgement of this request, another one corresponding to a potential dunning date if the concessionaire has not yet acknowledged or has not given any feedback, etc. And there are still many other fields and many other steps.
So at the beginning of my sub-table I created two selection fields containing different values. The first one is called "Stage of the connection request" defining at what point we are, and the second one is called "Status of the connection request" defining the status as for example "Problem", "Doing a follow up", "In process", etc.

(Sorry, I config my database in french because I'm french and it will be used by french persons)

As a result, it is these two elements that I want to modify "automatically" according to what has been updated or not as a field. My problem arises for the modification of the "Status of the connection request" since the time function comes into play. To continue with my examples, I would like my selection field to be updated according to the time when I enter the date on which the connection request was sent to the LoR: if it is less than 15 days from the date of the consultation and the date entered when the request was sent, then it tells me that it is "In process", otherwise it tells me to "Do a reminder".

(The code is also in french with french name fields)

Especially since all this must be done automatically since I want the selection field to inform me later of the status of the file in question (I will have more than 80 files in progress containing an average of 5 connection requests, so I can't have fun consulting them one by one, a dashboard will do it for me thanks to this selection field that I will only have to query thanks to a "select. . where...")

But this example is only one and it should be applicable to all the other fields that follow.

If you ask me why I didn't just put a function with a text, the problem is that I want to collect at the end the global state of my file in relation to all its connection requests. So, by collecting all the values of the two selection fields of the connection requests related to the folder, I can keep the one that is the most behind (I filled in the values of the selection fields so that the min(number('Selection Field')) is the one with the smallest or most worrying status) (I'll skip this part). That's why I go through a selection field whose value I can easily retrieve. While I can't "classify" by importance the style of text it will return.

I hope my explanations are clear enough.

Romain Zanon