0

Open record from other table by after update script

I have a table called "incidenten" and a field to add text to a log-field and certain words trigger other fields to be set a certain value. 

Now I also have a table called "Eenheden". When I typ ".geo ON2103" in a field in the incidenten table then I need the record to open from "Eenheden" where the field "Roepnummer" is "ON2103". How do I script that?

5 replies

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

    Something like this:

    let i := first(select Eenheden where Roepnummer like "ON2103")

    openRecord(i)

    Steven.

    • Stijn_Klaassen
    • 3 yrs ago
    • Reported - view

    Thanks for your reply. Now it searches for ON2103 but it needs to search whatever text is in that field. The fieldname is "Toevoegen"

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

    In the trigger after update of that field Toevoegen, or in a separate button, you can put this:

    let s := Toevoegen;

    let i := first(select Eenheden where Roepnummer like s);

    openRecord(i)

    Steven

    • Stijn_Klaassen
    • 3 yrs ago
    • Reported - view

    Thanks a lot! Seems to work

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

    Geweldig, graag gedaan Stijn.

    Steven.

Login to reply

Content aside

  • 3 yrs agoLast active
  • 5Replies
  • 1153Views