0

openTable issue

Hello -

openTable script stopped functioning.

Starting with 3.15 I have button scripts that direct the user to a table and view

openTable("Supplier", "Inventory")  .... has been working for months.

When the button is clicked the Supplier table is brought into view but not the Inventory tab.  It defaults to the first tab in the table rather that the one in the script.

Any ideas?

32 replies

null
    • Mel_Charles
    • 11 days ago
    • Reported - view

    With the release of 3.15.3 public web version the popup issue seems to be resolved ! 馃檪

      • spinner_7580
      • 7 days ago
      • Reported - view

       

      openRecord() not resolved on 3.15.4 Public Cloud and Mac app 

      • Fred
      • 4 days ago
      • Reported - view

      I just tried it on 3.15.4 (public cloud) and 3.15.2 (MacOS) and openRecord() worked for me.

      The first part of the video shows the record in Table2 with a tab called Jump. Then I switch to a Page, then click on a button with the following code:

      let x := first(select Table2 where Id = 2);
      openRecord(x, "Jump")

      You can see it opens a record and takes me to the tab called "Jump".

      • Rafael Sanchis
      • Rafael_Sanchis
      • 4 days ago
      • Reported - view

       

      I Fred yes work too on 3.15.3 on Android.

    • spinner_7580
    • 3 days ago
    • Reported - view

    Obviously I'm not grasping something fundamental here.

    I notice in your video that you get a "popover" window when the script goes to your Jump tab.  That is not the desired UI behavior I have been getting prior previously.

    In other words, I just want the page/tab view to change, i.e., no popover, which used to work.

    I've uploaded my sample DB.  I created a button with your script next to my sample button to show the behavior on my end using MacOS 3.15.4 ( switches to Destination table but not Destination Tab )

    Also, I don't understand why you added the Id reference in your script - doesn't the first operator indicate/imply Id=1?

    My sample button doesn't use the Id reference and mirrors the script format that I have been using successfully previously.

    kind regards...

      • Fred
      • 3 days ago
      • Reported - view

      Try moving the "all" table view to be the first view in the "Destination table" table. The Destination view in the same table is a form view and thus does not seem to allow Ninox to switch tabs.

      • spinner_7580
      • 3 days ago
      • Reported - view

       

      Thanks for the suggestion - tried that but still doesn't switch to the desired tab.

      • Fred
      • 3 days ago
      • Reported - view

      The Destination form will never switch. It should open a record from the all view then switch to the Destination tab.