Hi guys,
how can I save the current DateTime in a field only right after the user click SAVE to the form?
Solved! Go to Solution.
#1 - Create an action with โDo This:โ > โSet the values of some columns in this rowโ
#2 - Set the columns value as NOW()
#3 - Open the correct form view
#4 - Select that action with the option Events action > Form saved
One way is an โEvent actionโ that writes the value right after when you click save.
How to enable a event actionโฆpls help
#1 - Create an action with โDo This:โ > โSet the values of some columns in this rowโ
#2 - Set the columns value as NOW()
#3 - Open the correct form view
#4 - Select that action with the option Events action > Form saved
Hi @Aleksi ,
that worked perfect! Thanks.
Just a doubt, that field should have the current DateTime after save the form but only if the Status = โOkโ, if Status = โPendingโ, the DateTime field should be blank. How can I set both actions to the form? I see I can only set 1 action in the Events Action > Form saved:
as in screenshot below you can see you add a number of actionsโฆunder the heading Set these columns, to take place one after the otherโฆtry them outโฆin the expression field next to the column header you can add now() as the expression
This is what I have:
it works fine for that condition: [Status] = โokโ
But the same Field must set value โโ if the user set the [Status] = โPendingโ
on top of the screen shot below the expression field where you have entered now(), you can see a + icon, click on that to add multiple changes you require to happen at the same time
Yes, that is to set several values, but what about evaluate different conditions? I have to update the same field but evaluating 2 conditions:
if the Status = โokโ > Date Time = now()
but,
if the Status = โPendingโ > Date Time = โโ
thatโs what I need to do. Let me know if I am missing something.
in the date Time columnโฆsee to that there no initial value setโฆset it to blank and just select the appropriate data typeโฆover in the action spaceโฆenter date time as now()โฆthis should work
Under Actions Header โDo Thisโ select Grouped Actions from the dropdown to start with
@Geovany_Kelly You can set a condition rule as [Status]=โOkโ. If itโs not TRUE, the Event action is not triggered and nothing happens after the save. Only one Event action is needed.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |