DateTime initial value

AppSheet AppSheet Q&A
1

Hello everyone.

Although I filled the initial value with the NOW() expression, I still have this problem

1.PNG

2

What problem?

1 Like
3

I want to display it like this

1.PNG
1.PNG582Ă—104 3.06 KB

1 Like
4

You mean the Initial Value doesn’t seem to be working?

Is it a new or existing record?

https://help.appsheet.com/en/articles/961507-app-formulas-and-initial-values

1 Like
5

When i click on icon to edit it shows me the date and time of now.

it’s a new record

1.PNG
1.PNG340Ă—281 5 KB

6

Salut Rafik,

I have a dateTime column with NOW() in its Initial value, and it shows the current dateTime upon creation of row through a form. I did several tests changing several column parameters and couldn’t make it disappear. It always shows the current dateTime correctly.

I don’t know what would be causing this behavior. Perhaps you can post screenshots of your column’s settings so that we can troubleshoot. Thank you.

1 Like
7

@Joseph_Seddik @Marc_Dillon I’m sorry it is an existing record, and i think that’s the problem.

1 Like
8

Yes, an Initial value, contrary to an App formula, is calculated only once at row creation.

I think you have newly-added this column to your table and now want it populated, right? In any case, tell us please what you would like to do and we’ll tell you a solution for it.

1 Like
9

In fact i have several industriel devices which are stored in a table(Pieces), and i created another table(interventions) to add interventions for these devices. in the intervention form there is a column where i just want to display the name of the device that i want to intervene as a reminder as well as the column on wich we are talking. and here the problem started because i couldn’t find a methode to retrive the name of the device. The idea that came to my mind is to add the columns of the table (interventions) to (pieces) and instead opening the intervention form i will open a form to edit the current row (using slice) in order the retrieve the name of the device. after saving a used the action(add new row using action from this riow).

Thanks a lot for your answers @Joseph_Seddik @Marc_Dillon

10

Hello Rafik, please post screenshots of the columns of both your tables. Thanks.

1 Like
11

It’s good i found the solution. Thank you so much @Joseph_Seddik

1 Like
12

The solution is to check (reset on edit)

1 Like