Skip to main content

Ninox-Documentation

Sean

Sean

1758
78
0

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

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: Find Date?
Menu/View/Find in View or Command+F.
- Sean
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 yrs ago
- 1reply
- 1222
- 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
- 6 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
- 6 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
- 6 yrs ago
- Get help
- Reported - view
Re: Automatically updating a field
In your original post you say: "Expires": date(year(Date) + 1, month(Date), day(Date)) You did not show that you have used last() for this field. If that is the case and you have multiple records and…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Automatically updating a field
You mention that you have a formula: last(Table2.Expires) , but that is not what you are referencing in the if-then-else statement.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Automatically updating a field
Is the "Current?" field the formula field that has: if Table2.Expires < today() thenstyled("EXPIRED", "red")elsestyled("Current", "")end ? last() is not being used there.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Automatically updating a field
In the MEMBERS table where you have the formula: if Table2.Expires < today() thenstyled("EXPIRED", "red")elsestyled("Current", "")end did you use last()?…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How to reference choices in a formula when the choices have no text
I agree with @blackie. Also, you can set up a view that shows only the icon fields and when you select a record to edit it will show the the governing fields so you can change the status.…
- Sean
- 6 yrs ago
- Get help
- Reported - view

1 65 66 67 68 69 70 71

Back to top

Ninox-Documentation

Overview

View all topics