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: Filter not working for Formula
Yeah, I get the same result and it doesn't make sense. The filter works in a View layout element which makes me wonder if it not working in the Table view is a bug.…
- Sean
- 4 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?
This was one of those facepalm realizations... for oneRec in select OneTable dofor manyRec in select ManyTable where Text = oneRec.Text domanyRec.(OneTable := oneRec.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Function for attachment count
You can use count(files(this)). Here is a link to the language reference... https://ninox.com/en/manual/calculations/reference-of-functions-and-language
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Link records in 2 tables
Your code uses the unique() function so that will cause a problem. Is the CodiceCliente field a text field? What do you mean by, ""CodiceCliente" field is enhanced"?…
- Sean
- 4 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?
Here is another version that will link two tables (1:N). Note, this only works in the Mac app and, I assume, the iPad app. I have tried it in the browser version and it does not work.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Link records in 2 tables
Per support, sometimes code that works in the Mac app will not work in the browser version.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Link records in 2 tables
Two more points. One, if you have duplicates in your 1 table, the linking will attach the N table records to the last duplicate of the 1 table based on Id sort order.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Link records in 2 tables
Hello, I would first like to point out that I am not a Ninox employee. Secondly, if you read the entire thread you will see that others have sucessfully used this approach to link their tables.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Link records in 2 tables
Please see this thread...…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: what is the formula to obtain the standard deviation ?
There's more than one way to do it. The first example uses the select command to access the records... let setCnt := cnt(select YourTable);let mean := sum((select YourTable).…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Great experience
Are you leaving?
- Sean
- 4 yrs ago
- Learn and Share
- Reported - view
Re: views populated with an array
I wasn't able to do it, but that doesn't mean it can't be done. In my opinion, it would be a lot easier/cleaner to just create a table for this purpose. https://ninox.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way to query REST API in order to get only a subset of the data
I think this is something they are working on. https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/ninox-http-calls-syntax-5c83993071d2ba74f1399907
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Quotes automatically inserted around text fields when copying and pasting
You can use the same query in a formula field and you won't get the double quotes. I would create a new table and put the formula there so it's not duplicated across all records in the source table.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Console Window Input Panel
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Fault
I copied and pasted your formula and when I replaced the trailing quote it worked. function test() doalert("This is the alert message")end;test()
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: openFile <-> openURL
The app is set as default for all PDF files and that is why said double-clicking on the same file in Finder opens it in the default PDF app. The PDF file opens in the default app if I click on an…
- Sean
- 4 yrs ago
- Learn and Share
- Reported - view
Re: openFile <-> openURL
I tried openURL("file:///...") in a button "On click" and it still opens my PDF file in Preview instead of my default PDF app. When I double-click on the same file in Finder it opens in the default…
- Sean
- 4 yrs ago
- Learn and Share
- Reported - view
Re: Undo function
For anyone who is interested, I uploaded an "Undo Example" database to the Webinar EN 2020 team. It is currently protected because I'd like for it to be tested the way I intend for it to be used.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Can I automatically enter different choices from a table into a Combobox from another table depending on the choice from another Combobox?
You are correct that it is not possible to create Choice fields on the fly, yet. I would use a switch statement instead of nested if-then-else statements, but that's a personal call.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Building your own Function?
When you assign the result of a select statement to a variable, the variable will be an array not a proxy name for the table. I can't get my version of tbl.Abr to work at all.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Building your own Function?
You can't use a variable in place of the table name when you use the select statement. If you want to use a function that you can pass a table name into,…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Building your own Function?
The argument types are limited as you found out. What do you want to do with the table name once it is passed to the function?
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How to trigger two things at once using 'if, then else'
Hi, try this... Trays := true; 'Trays Start Date' := 'Propagation Date'
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: I'm looking for a way to filter and delete records after import
Did you look at the Delete records section here?? https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
- Sean
- 4 yrs ago
- Get help
- Reported - view

1 34 35 36 37 38 71

Welcome to the Ninox community

Sean

My Posts

Re: Filter not working for Formula

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

Re: Function for attachment count

Re: Link records in 2 tables

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

Re: Link records in 2 tables

Re: Link records in 2 tables

Re: Link records in 2 tables

Re: Link records in 2 tables

Re: what is the formula to obtain the standard deviation ?

Re: Great experience

Re: views populated with an array

Re: Is there a way to query REST API in order to get only a subset of the data

Re: Quotes automatically inserted around text fields when copying and pasting

Re: Console Window Input Panel

Re: Fault

Re: openFile <-> openURL

Re: openFile <-> openURL

Re: Undo function

Re: Can I automatically enter different choices from a table into a Combobox from another table depending on the choice from another Combobox?

Re: Building your own Function?

Re: Building your own Function?

Re: Building your own Function?

Re: How to trigger two things at once using 'if, then else'

Re: I'm looking for a way to filter and delete records after import

Overview