Sean

1760
79
0

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

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Print
Another option for now() is this. let txtNow := text(number(now())); It will generate a file name like this... 1540416426537 mypdf.pdf
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Change
This information is available at the link I posted above. If you go to that link and type command+f, your browser should popup a search box where you can enter the search term; format in this case.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Print
I'm using the now() function because that was the original solution. I would probably use a different auto increment scheme, but I'll stick with now(). This should work.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Change
format(number, format mask) - Converts a number into a formatted text. https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Print
It turns out that ":" is also a problem. You can use now() so a new document is produced each time, but you have to replace "/" and ":". This is how I did it.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Print
The problem is the "/" generated by the now() function. You can use the format function to remove the "/". This is what I did and it worked correctly. let txtPDFName := format(now(),…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Display first two characters
That's what happens when one assumes things! :-D
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Display first two characters
I assume you want to retain the complete text, but only display the first two left characters. In that case I would create a field that stores the complete text, but is hidden.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Why does hitting return or escape cause the computer to beep? It should simply register the value you've entered, or leave the field (in the latter case).
LOL. Agreed!
- Sean
- 6 yrs ago
- Learn and Share
- Reported - view
Re: How can you tell what version of NinoxDB I am on?
Yeah, I'm surprised "About" does not reveal the version number. This is probably not the answer you're looking for, but the only way I know of is to open the App Store and find it there.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Next row
This thread might help. https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/how-to-create-a-button-that-clicks-through-forms-5bb0eab6ee4fde095b30856b
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How do I calculate the average?
Click on the column header that you want to average and a window will popup that will give you options to choose from. Average is one of the available options.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: is it possible to flash a colored field?
lol
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How to move a line?
Sounds like the table is being sorted in a way you're not expecting. Check your column headers for the ^ symbol or the upside down version of it. I don't think it's possible for the table to be…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: is it possible to flash a colored field?
smh rme
- Sean
- 6 yrs ago
- Get help
- Reported - view
An alternative to the Input Dialog

I know there isn't an Input Dialog in Ninox - yet ;-), but when it is available I have to wonder if it will have the flexibility of a Form. After I posted in the field with some ranking property…
- Sean
- 6 yrs ago
- 2499
- Get help
Re: field with some ranking property
I just wanted to update my post with a little more explanation. I don't know if this is what is referred to as a "Use Case", but the task is to auto update Rankings in a table.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Find index position of a value within an array
You can use a while loop to find the index number and then use the slice() function. let i := 0; while item(array, i) != “Tom” do i := i + 1 end You might have to use text(item(array,i)).…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: field with some ranking property
It's possible, but the only way I can see it working is with two rank fields so you can compare. This scenario is crying for a dialog box that allows input.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Find index position of a value within an array
I know I can do item(array,'b') to get '1' It's the other way around... item(array, index). Index must be a number. You could compare each index item until you get a match.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How do I filter out one or more field values?
If you set it up like this, you'll only need to push the button once. let aryItem := ["Apples", "Oranges", "Bananas"];for i in range(0, 3) dofor f in select Table1 doif text(f.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How do I filter out one or more field values?
One more line of code and you'd only have change it each time. On the first line enter: let myItem := "Action Figure"; And where "Action Figure" is in the loop you would replace it with myItem.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How do I filter out one or more field values?
I'm giving it another try. What you could do is duplicate your database just to be on the safe side, create a Choice field that has all the choices that your Multiple Choice field has and attach the…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How do I filter out one or more field values?
It's looking for a field that has both "Advertising" and "Battery Powered" stored in it in your example.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How do I filter out one or more field values?
It's because you are trying to filter a Multiple Choice field. I used a Choice field not knowing what you used and when I tested using a Multiple Choice field I got the same result you did.
- Sean
- 6 yrs ago
- Get help
- Reported - view

1 65 66 67 68 69 70 71

Welcome to the Ninox community

Sean

My Posts

Re: Print

Re: Change

Re: Print

Re: Change

Re: Print

Re: Print

Re: Display first two characters

Re: Display first two characters

Re: Why does hitting return or escape cause the computer to beep? It should simply register the value you've entered, or leave the field (in the latter case).

Re: How can you tell what version of NinoxDB I am on?

Re: Next row

Re: How do I calculate the average?

Re: is it possible to flash a colored field?

Re: How to move a line?

Re: is it possible to flash a colored field?

An alternative to the Input Dialog

Re: field with some ranking property

Re: Find index position of a value within an array

Re: field with some ranking property

Re: Find index position of a value within an array

Re: How do I filter out one or more field values?

Re: How do I filter out one or more field values?

Re: How do I filter out one or more field values?

Re: How do I filter out one or more field values?

Re: How do I filter out one or more field values?

Overview