0

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

null
    • Sean
    • 4 yrs ago
    • Reported - view

    Are you referring to the main Table view or the View layout element?

    • Peter_Helbo
    • 4 yrs ago
    • Reported - view

    It is a Viewer layout element.

    • Sean
    • 4 yrs ago
    • Reported - view

    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?

    • BugTrapper
    • 4 yrs ago
    • Reported - view

    Automatic refresh is not possible, only a trigger, if database will be be opened (in options of database)

    • Sean
    • 4 yrs ago
    • Reported - view

    @BugTrapper, I guess I must be special because it works for me. FYI, I rarely post a comment without testing first.

    • BugTrapper
    • 4 yrs ago
    • Reported - view

    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.

Login to reply

Content aside

  • 4 yrs agoLast active
  • 6Replies
  • 2114Views