Sean

1762
79
0

Joined: Tue Jul 31 23:45:13 UTC 2018

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Function parameters - which types are possible
@John Halls first() and last() functions also return a Ninox Id (nid) like "this" does. I tried variations of what I thought they were returning (record Id, table letter + record Id, etc),…
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@Jacques TUR Maybe something is getting crossed in translation, but yes, you can pass a table object or a record object as an argument to a user defined function. Your example uses a table object.…
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
So this looks like a bust. It would be nice to be able to either pass the table name as an argument or somehow get "this" to work in a global context. I tried to use a number instead of using the…
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@RoSoft_Steven I don't think "this" can be used in a "Global function". If you get it to work let me know.
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@Jacques TUR
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@Jacques TUR That’s not what what I am asking about.
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@Jacques TUR I don't think that will work in a global context. I get... "Keyword not defined in this context: this at line 2, column 90" when I use it in the Console. I tried using t.…
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
Hi Jacques, In the record() function you use Customer for the table name. To me, that seems to be hard coding the function. Do you know if there is a way to use a variable there?
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@Jacques TUR In the last example, do you know of a way to substitute the actual table name in the record() function? Otherwise, you might as well just use the select statement in the function…
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: while loop stops before reaching end
This is definitely a weird one. I have the Mac app on my old (2015), but still functional MacBook Pro. I get the same results as @schwiegel and @Nick when I use the while loop,…
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Database size spiraling out of control
@simon It isn't necessary. My statement assumed everyone wants their new database to have the same name as the old one. Since the Ninox Mac app won't let you create a duplicate database with the…
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Database size spiraling out of control
In addition to this topic... https://forum.ninox.com/t/h7hrzg3 I would add that any changes to the database schema also causes bloat. The old schema remains in the database and the new modified…
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
@Mike My guess is because Ninox isn’t an SQL DBMS
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Image copy from Child Table to Parent Table
@RoSoft_Steven Have you gotten this to work in the Mac app with local images?
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: All I want for Christmas!
Maybe better phrased as the guy who understands their minified code well enough to hack it.
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: All I want for Christmas!
@Jacques TUR said: and not have to do complicated functions Says the guy who is hacking their code!
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
@Mariner of the Sea of Cortez Hi Dan, You used double quotes for the field -Log Date- which makes it a string. Try it with single quotes and it should work.
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: add onselect event for view field
@Fred Because his code is searching for the first class named "component editor editor-list editor-4col" and your View wasn't first. If you changed the Reference fields to "Show as...…
- Sean
- 2 yrs ago
- 1
- Learn and Share
- Reported - view
Re: add onselect event for view field
Correction, you can't have a 1:N Reference field before the View, but you can have one after the View.
- Sean
- 2 yrs ago
- Learn and Share
- Reported - view
Re: add onselect event for view field
@Fred I deleted the Reference fields Table2, Table22 and child from Table1, closed and reopened the database and it worked. It looks like you can't have a 1:N Reference field in the same table.
- Sean
- 2 yrs ago
- Learn and Share
- Reported - view
Re: add onselect event for view field
@Fred It works for me in the Mac app. I set it up like you did, assigned the return value to a text field, and I get the alphanumeric value (TableId/RecordId).
- Sean
- 2 yrs ago
- Learn and Share
- Reported - view
Re: ExtractX help!
@John Halls You would use the Ninox http() function to access the Dropbox API. I don’t have a Dropbox account, but I did confirm Dropbox has an API.
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: ExtractX help!
Hi @SoluMaker That looks like JSON, but it has some format errors. Did you modify the text in any way? if I cut the section you want to get timestamps from...…
- Sean
- 2 yrs ago
- Get help
- Reported - view
Re: Set auto completion on Ninox editor
@Jacques TUR said: Each module has its own version number which is displayed in the initialization form. The version number of the main module is displayed all the time,…
- Sean
- 2 yrs ago
- Learn and Share
- Reported - view
Re: extractx() “g” flag workaround
I readily admit I'm not the best communicator and I have a tendency to underexplain rather than overexplain a point. I figure if someone needs clarification they will ask .…
- Sean
- 2 yrs ago
- Learn and Share
- Reported - view

1 9 10 11 12 13 71

Welcome to the Ninox community

Sean

My Posts

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: while loop stops before reaching end

Re: Database size spiraling out of control

Re: Database size spiraling out of control

Re: Complex Select statement for View

Re: Image copy from Child Table to Parent Table

Re: All I want for Christmas!

Re: All I want for Christmas!

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: add onselect event for view field

Re: add onselect event for view field

Re: add onselect event for view field

Re: add onselect event for view field

Re: ExtractX help!

Re: ExtractX help!

Re: Set auto completion on Ninox editor

Re: extractx() “g” flag workaround

Overview