Sean's Profile | Ninox Community

Latest Posts

Re: Hey ! Do you want another tricky question ??? Again concerning sorting…
I guess I'm not sure what you mean by "tablular mode" unless you are referring to the table view. If you are referring to the table view, that solution works.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Hey ! Do you want another tricky question ??? Again concerning sorting…
You are! 😎 This requires another Formula field and this is the code I used... let t := this;count(select YourTable where Choice = t.Choice)
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How to show only the first line of a multi-line field?
Westy, Try this... var firstLine := item(splitx(theString, "\n"), 0)
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Tricky question about sorting for ninox experts…
Laurent, If you want to automate updating the rank/order of choices then using a "Choice Table" instead of a "Choice Field" is the way to go.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Tricky question about sorting for ninox experts…
You can precede your Choice names with a number similar to how you can order views or you can recreate the Choice field with the items in the desired order and use a formula like…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Clicking a Table entry hides the table. How do I do this?
Mr. K, I watched your video. I don't know why your Form view left margin isn't going all the way over. It does on my computer using Mac version of Ninox even when I put it in full screen mode.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Clicking a Table entry hides the table. How do I do this?
LOL, Sorry Mr. K, you can lead a horse to water... I'm not going to make a video for you, but that's how you do it.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Clicking a Table entry hides the table. How do I do this?
If you move your cursor over the left edge of the form view, you should see the column width adjustment symbol. Click on the left edge and drag it all the so that it covers the table view.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: html() function
Karen, You bet! I didn't figure out until just recently that the html() function practically turns the formula field into a browser window. This is the description in the language reference...…
- Sean
- 6 yrs ago
- Learn and share
- Reported - view
Re: html() function
Steven, You're welcome. I'm glad you liked it and thanks for commenting!
- Sean
- 6 yrs ago
- Learn and share
- Reported - view
Re: html() function
I added a custom table view.
- Sean
- 6 yrs ago
- Learn and share
- Reported - view
Re: is it possible to copy a view?
@herman, The Import function is how you get to Data Model which allows you to copy the Form View. That's why it was being discussed.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: is it possible to copy a view?
I might be missing something here, but you can import an existing Data Model from another Ninox database and the existing form view will be copied with that import.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: linked tables
Andrea, take a look at this thread... https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/how-can-i-automatically-link-two-fields-from-two-tables-5c8cfc004a46f37365e3968f
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How to submit data from a html form to a Ninox Cloud solution?
I haven't done this yet, but you should check out the API instructions. https://ninoxdb.de/en/manual/api/api-introduction
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How does the View Layout Element work?
select YourTableName - to select all records from that table or select YourTableName where YourFieldName = "YourFilterCriteria" - to filter records from that table.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Calculate a future date
I just picked an existing formula of mine that returned a date so I could eliminate the easy solutions first. I just now got a chance to look at your formula more closely and it looks like the issue…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Calculate a future date
Make sure Number format is empty...
- Sean
- 6 yrs ago
- Get help
- Reported - view
html() function

I uploaded a database named HTML Tricks. So far it only has one example, but I've got some other ideas I've been playing with. If you are interested in a blinking formula field you should give this…
- Sean
- updated 3 yrs ago
- 31replies
- 6280
- 2
- Learn and share
Re: is there a way to set currency format in formula field ?
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Calculate a future date
https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language Try using the date() function. The result was 06/15/2019 for me.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: user defined function - appendArrays
The following code works... let mySquare := [3, 6, 7, 8];let myRow := [3, 7];let myCol := [3, 7, 9];let subNumbers := unique(mySquare, myRow, myCol);let posNumbers := [0];let allNumbers := [1, 2, 3,…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: user defined function - appendArrays
Hopefully, this better explains the difference between a plain ole formula and a user defined function...
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: user defined function - appendArrays
Chris, Pretty much any unique formula is a user defined function. I guess what separates a formula from a function is that you are wrapping the formula in the function format then you can call the…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Help with a formula
Nick, try this... switch Score > 0 and Score <= 100 docase Score >= 90 and Score <= 100:"EXCELLENT"case Score >= 75 and Score < 90:"SATISFACTORY"case Score >= 60 and Score < 85:…
- Sean
- 6 yrs ago
- Get help
- Reported - view

1 50 51 52 53 54 71

Welcome to the Ninox community

Sean

Re: Hey ! Do you want another tricky question ??? Again concerning sorting…

Re: Hey ! Do you want another tricky question ??? Again concerning sorting…

Re: How to show only the first line of a multi-line field?

Re: Tricky question about sorting for ninox experts…

Re: Tricky question about sorting for ninox experts…

Re: Clicking a Table entry hides the table. How do I do this?

Re: Clicking a Table entry hides the table. How do I do this?

Re: Clicking a Table entry hides the table. How do I do this?

Re: html() function

Re: html() function

Re: html() function

Re: is it possible to copy a view?

Re: is it possible to copy a view?

Re: linked tables

Re: How to submit data from a html form to a Ninox Cloud solution?

Re: How does the View Layout Element work?

Re: Calculate a future date

Re: Calculate a future date

Re: is there a way to set currency format in formula field ?

Re: Calculate a future date

Re: user defined function - appendArrays

Re: user defined function - appendArrays

Re: user defined function - appendArrays

Re: Help with a formula

Overview