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: Update File Value Linked Table
Do you get a dropdown or a popup window with a list to choose from? When I select a linked field, I get a popup window that lets me choose from the linked table.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I format the field text longer
While that wrench in the upper right corner of your screenshot is in the red circle, you can click on any of those sliders and adjust the size to make the text visible.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to make a smaller save size with an archived database?
Which platform are you using Ninox on? I'm using it on macOS.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to make a smaller save size with an archived database?
In the home screen of your database file you can choose "Export data". You'll see a popup dialog that lets you choose from CSV export, Excel export and Ninox.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Global Script Definition for Specification of Quarters and Fiscal Years
You would pass the dates to your function as arguments. function report(startDate : date, endDate : date)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to select more than one option from a multiple choice when creating a record from a button?
To preselect choices you will need to use a numeric array. Something like mcField := [1, 3, 5] will set the first, third, and fifth choices of the multiple choice field.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How do I utilize a tooltip?
Are you hovering the mouse pointer over the field you added the tooltip to? I've tried it with a Text field and Formula field and they both work.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I change a field type - from text to choice?
If you have any questions about the process, I can explain it in more detail.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I change a field type - from text to choice?
Um, you can't "convert", but you can copy the values in your text field to a choice field as I described here...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Function result from multiple tables
What does it display if you just have INSTRUMENTATION.Total in the formula field?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Function result from multiple tables
Try number(INSTRUMENTATION.Total)... It looks like you are trying to multiply with a field that is being stored as type array.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How can I change a field type - from text to choice?
The easiest way would be to click on the Administration icon (wrench) in the upper right corner and then select the "Console" tab. Type this code using your table and field names and click run.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Windows version ???
Subtle
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
No worries, I think that behavior might have to be fixed by the Ninox Team.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Trigger After Open
Nick, I'm confused. Are you using it differently now than before? It still works for me.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Create a Summary from field inputs
Use a formula field for the sentence and enter something like this in the formula... "Paul walked " + Field1 + " miles in " + Field2 + " minutes."
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Total of a field in all records.
If you click on the column header of "how many", you'll get a popup with some options. Choose "Sum" and the total will be displayed at the bottom of that column.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Universal array handling when array items are not text strings
Why not? If you want to insert... let array := [0, 20, 30, 40];let max := cnt(array) + 1;let iLoc := 2;let iItem := 75;var newArray := for idx from 0 to max doif idx < iLoc thenitem(array,…
- Sean
- 5 yrs ago
- 1
- 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?
Sorry again! Please use something other than "duplicate" because that is already command in Ninox. You could use "confirm" let confirm := dialog("Attention", "Create a duplicate record?", ["Yes",…
- Sean
- 5 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?
Ok, my brain caught up. The record has already been created, but the code won't let the duplicate information be entered. Here's a solution... if cntFirstName > 1 and cntLastName > 1 thenlet…
- Sean
- 5 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?
Sorry, it should be... if duplicate = "Yes" then
- Sean
- 5 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?
It's been a while since I've looked at this... I don't see where the record is created in the code above, but if it's working for you then that's all that matters.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: I can pass a record as a function argument!
mkay... I don't think you can name records. So based on my own testing I'll assume you meant table instead of record. Scope is an issue... Since it doesn't work in the console,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How does the location field work on iPad?
I've never used it, but it is discussed here... https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/default-value-for-location-lat-long-5bc2208213e90e0528f18b06?…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Question
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 60 61 62 63 64 71

Welcome to the Ninox community

Sean

My Posts

Re: Update File Value Linked Table

Re: How can I format the field text longer

Re: How to make a smaller save size with an archived database?

Re: How to make a smaller save size with an archived database?

Re: Global Script Definition for Specification of Quarters and Fiscal Years

Re: How to select more than one option from a multiple choice when creating a record from a button?

Re: How do I utilize a tooltip?

Re: How can I change a field type - from text to choice?

Re: How can I change a field type - from text to choice?

Re: Function result from multiple tables

Re: Function result from multiple tables

Re: How can I change a field type - from text to choice?

Re: Windows version ???

Re: Trigger After Open

Re: Trigger After Open

Re: Create a Summary from field inputs

Re: Total of a field in all records.

Re: Universal array handling when array items are not text strings

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

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

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

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

Re: I can pass a record as a function argument!

Re: How does the location field work on iPad?

Re: Question

Overview