0

Could someone explain to me please how to use the Trigger after open?

Hello, 

Could someone explain to me please how to use the Trigger after open? 

When I click on it it s all empty...

Thank you

9 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    It's the same as the trigger after open of a table only this one fires on opening the Database. 
    An use example is to open a record or table fullscreen. Here's an example:

    https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/simple-log-in-system-with-datetime-registration.-5e11d00509d132371a594f5c

    Steven

    • Nick
    • 3 yrs ago
    • Reported - view

    Another option (really useful to me) is to open a specific table and view upon opening like this:

    ---

    if getPlatform() = 3 then
    openTable("Journal", "iPhone")
    else
    if getPlatform() = 4 then
    openTable("Journal", "Android Phone")
    else
    if getPlatform() = 2 then
    openTable("Journal", "iPad")
    else
    openTable("Journal", "All")
    end
    end

    ---

    Sorry steven for jumping in...

    • Nick
    • 3 yrs ago
    • Reported - view

    Sorry I meant Steven (not steven)

    • maroon_banana
    • 3 yrs ago
    • Reported - view

    Thank you Nick and Steven

    The issue I have is that when I try to do a Trigger after open it's all blank (This picture above) so it doesn' t let me program anything if that makes sense...

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    You mean there are no fields on the left side? That is normal ( there are no tables loaded), you can go in the editor and type your code...

    • maroon_banana
    • 3 yrs ago
    • Reported - view

    Thank you for your reply Steven. 

    I'm not really good with Ninox.. I do have tables in my database, what do you mean by go to the editor and type your code...

    Thank you for helping :)

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    AED7F6BE-32DD-451A-B6EF-BA4773D860C1

    • maroon_banana
    • 3 yrs ago
    • Reported - view

    Thank you Steven

    I've done that but when I type my code it says that the field is not found. Do we have to code differently than a normal Table when coding there? 

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    You can see this as if you are working in the root of the database, there are no fields available because no tables have been addressed. You can do this by first choosing a table with the select command or the record command. This is kinda similar to a view in a form.

Content aside

  • 3 yrs agoLast active
  • 9Replies
  • 1570Views