How to update a view automaticcaly ?
I have made a todo database where it is possible to have a todo item that will repeat with a specified interval.
When ever I mark a repeateble todo intem it will:
- calculate the next todo date
- reset the done status
- close the form window and return to the view.
If I have a view ex. today which has a filter: date = today the todo item with the new date should not show up. If I update the view manually it will disapear but I would like to do that automatically but can't find any command for it in the reference.
So the question is: How can I force a view to update from the trigger code ?
6 replies
-
Are you referring to the main Table view or the View layout element?
-
It is a Viewer layout element.
-
If, you are using a formula in the View layout element similar to this...
select YourTable where YourDateField = today()the View should automatically update. How are you manually updating the View?
-
Automatic refresh is not possible, only a trigger, if database will be be opened (in options of database)
-
@BugTrapper, I guess I must be special because it works for me. FYI, I rarely post a comment without testing first.
-
There are many views and it is not really clear, what he meant. I thought time periodically refresh and this is not possible. If it is a view inside a form, you are right.
Content aside
- 5 yrs agoLast active
- 6Replies
- 2151Views