Sean's Profile | Ninox Community

Latest Posts

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
- 7 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
- 7 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
- 7 yrs ago
- Get help
- Reported - view
Re: Can a field appear on TWO tabs of the same form view?
If you don't need to edit the field on more than one tab, you could just create a formula field using that field as the formula.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: How do I filter out one or more field values?
This is not as simple as just being able to choose "Not", but it is available. Simply select all of the items you want to see and not the "Clock" item.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: How to create a button that clicks through forms
Cool. I enjoy working with the app also and I'm looking forward to the next release which will hopefully include some of the enhancements we have been asking for.…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: How to create a button that clicks through forms
Hey Nick, I'm confused. You seem a little hostile and you responded with a workaround yourself. I simply thought it was an interesting exercise and I am aware that those navigation controls exist.…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: How to create a button that clicks through forms
I don't know if this is still relevant, but this is a solution I came up with for sorted views. Next Record: let txtThisName := NameField;let aryNames := (select Table1)[NameField > txtThisName].…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: How can I set a field to automatically search existing records for possible duplicates of the record I'm about to create?
On the left side of the Edit Fields window you will see "Trigger on create". Enter the formula there.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Changing the size of the fields.
If I may make a suggestion, you could place a space layout element on your form where the hidden field would go. When the choice is selected you can hide the space element and reveal the field and…
- Sean
- 7 yrs ago
- Learn and share
- Reported - view
Re: Ways to list views
Precede your view names with a number and you can order them any way you want.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Drop out of a FOR loop early
Once the condition is met, set your loop variable to a value greater than your maximum loop value.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: New line in text-field
So, to accomplish what you want to do you would create a formula field and below/after that you would create a text field. In the formula field's formula you would enter:…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: New line in text-field
What you show there can only be a formula field and they can only be modified through code not in the edit screen.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Find Date?
That's funny. I missed the most obvious way to get to it! It does have a different search method than Find in View. When I entered 2018, it did bring up my records for that year though.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Find Date?
Menu/View/Find in View or Command+F.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: change single items of an array
let myArray := ["a", "b", "c"];myArray := [item(myArray, 0), "f", item(myArray, 2)];alert(text(myArray)) It's not great, but it does preserve the values you don't want to change.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: How to append values to an array
let myArray1 := [1, 2, 3];let myArray2 := [4, 5, 6];let myArray3 := myArray1 + myArray2;let myArray4 := [item(myArray3, 0), item(myArray3, 1), item(myArray3, 2), item(myArray3, 3), item(myArray3, 4),…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: How to append values to an array
It might be an array, but the only funtions I could get to work with my test array are item() and slice().
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: How can I add text to a number field?
I don't believe this is possible. You can either leave it blank or assign a numeric token for "Not Known" like 99999. You can enter numbers into a text or formula field however.
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Default View when opening a database
To be clear, I mean that you would set the default Table View and when you open the database it would open to that view.
- Sean
- 7 yrs ago
- Learn and share
- Reported - view
Default View when opening a database

It would be helpful to have the option to set a default Table View when opening a database.
- Sean
- 7 yrs ago
- 1reply
- 1224
- Learn and share
Re: Avg and sum in the same table
In the "Items" table you would have formula fields for each "Item Type". if ItemType = 1 then Item end if ItemType = 2 then Item end . . if ItemType = n then Item end You can group by "Item Type" and…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Avg and sum in the same table
If I understand correctly, In the items table I would have a field for "Items" and a field for "Item Type" as a choice field. The records would be the marks you have for the "Items" and you would…
- Sean
- 7 yrs ago
- Get help
- Reported - view
Re: Avg and sum in the same table
Assuming you have a table for Students and a table for Items, you could create a formula field in the Student table. Field Mark Sum would have a formula sum(Item.Mark)
- Sean
- 7 yrs ago
- Get help
- Reported - view

1 65 66 67 68 69 70 71

Welcome to the Ninox community

Sean

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: Can a field appear on TWO tabs of the same form view?

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

Re: How to create a button that clicks through forms

Re: How to create a button that clicks through forms

Re: How to create a button that clicks through forms

Re: How can I set a field to automatically search existing records for possible duplicates of the record I'm about to create?

Re: Changing the size of the fields.

Re: Ways to list views

Re: Drop out of a FOR loop early

Re: New line in text-field

Re: New line in text-field

Re: Find Date?

Re: Find Date?

Re: change single items of an array

Re: How to append values to an array

Re: How to append values to an array

Re: How can I add text to a number field?

Re: Default View when opening a database

Re: Avg and sum in the same table

Re: Avg and sum in the same table

Re: Avg and sum in the same table

Overview