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.
It is possible that Ninox has updated the behavior of functions or the methods of accessing data, causing incompatibilities with scripts. I wonder if a fix for this, which seems to be a bug, is on the agenda.
Fred
yesterday
Reported - view
I'm not able to reproduce it in public cloud 3.15.
spinner_7580
yesterday
Reported - view
Maybe I tricked myself regarding the opeTable command. I actually have 2 commands in the button script (sorry for the confusion in my original post):
openTable("Supplier", "Inventory");
openRecord(first(select Supplier),"Inventory")
I can confirm that in Mac app 3.14.3 the above script will leave the LaunchPad table and switch to the Supplier table and display the 3rd tab in the Supplier table. -- this is the desired behavior.
However, if the script is simply:
openTable("Supplier", "Inventory")
In Mac app 3.14.3 the script will leave the LaunchPad table and switch to the Supplier table but display the first tab - ignoring the tab parameter "Inventory"
When I was messing the the database on the clients public cloud 3.15 I could copy and paste a "fresh" version of the first script above and the behavior would "work" the first time, i.e, Leave LaunchPad table and land in Supplier table tab 3 (Inventory) but, subsequent "button clicks" would yield the behavior of leaving the LaunchPad table and landing in Supplier table tab 1.
Scripts that switch between tabs of the same table work using the openRecord command.
I guess the openTable command never really "worked" in that it simply switches to the named table and lands on the first view, whatever it is, and ignores the named view parameter.
Apparently, since I paired it with the openRecord command I got the result I wanted.
So, again in Mac app 3.14.3
By itself, openTable("Supplier", "Inventory") only switches from the LaunchPad table to the Supplier table but ignores the tab parameter and instead lands on tab 1
By itself, openRecord(first(select Supplier),"Inventory") switches from the LaunchPad table to the Supplier table and lands on the Inventory tab (tab 3)
Fred
yesterday
Reported - view
I just tried on Mac app v3.14.3 and was not able to duplicate. I have a button with just openTable(). I tried it using a Public Cloud DB and a local DB and both instances the button took me to the table and view. My view is a table view.
What kind of view is Inventory?
Can you upload a copy of the DB with just one record?
spinner_7580
15 hrs ago
Reported - view
Hi Fred -
The LaunchPad where the button is located is a form view. The LaunchPad associated table just has one record.
The Supplier table has many records and has one form view with 3 tabs. The button used to land on the form view tab 3 (Inventory) now it lands on tab 1.
As mentioned, I can get the public cloud 3.15 version button to work once after "refreshing" the script.
Uploading the DB would be problematic since there are lots of references in field names and the like that are proprietary.
I might be convinced to DM to you at the great risk of you laughing me for what is likely crummy programming compared to the likes of your gteat expertise!
Fred
13 hrs ago
Reported - view
I've tried it with a form view and still no issues, in public cloud.
