Sean's Profile | Ninox Community

Latest Posts

Re: How can I copy from a text field to a date field?
This should do it... let firstIndex := index(TextDate, "/");let secondIndex := if substr(TextDate, firstIndex + 2, 1) = "/" thenfirstIndex + 2elsefirstIndex + 3end;date(number(substr(TextDate,…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How can I copy from a text field to a date field?
It’s still possible, just take a little more code. It will be a few hours before I can work on it again.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How can I copy from a text field to a date field?
You can use "Update multiple records..." The formula below assumes the text date is in the format of Day/Month/Year. Make sure you have created a Date field to copy the value to.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: New formula field formatting
@Mconneen, styled() was broken, but has been fixed with version 2.5.4. What I was referring to was setting the background color using the new “Style” feature.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Coding for Buttons
You can use this code in a button to select a view... openTable(tableName, viewName) - opens a table view| openTable("Invoices", "All Invoices") This thread should help for autofill...…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: New formula field formatting
Version 2.5.4 fixed the problem with styled() function not displaying in the form, but using the "Style" option for the formula field still only works for Form View.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Make (fx) field properties available in the editor

Version 2.5.4 is a great update for UI building and I'm surprised it didn't get a blog mention. My request probably ranks below new array functions in popularity 😁,…
- Sean
- 6 yrs ago
- 2replies
- 980
- Learn and share
Re: New formula field formatting
I agree. It would be perfect for that field type.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: New formula field formatting
Nick, don't you throw my words back at me young man! 😁 Thanks for explaining "Placeholder". When I read the update notes before downloading, I guess I combined the two new features in my head and…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: New formula field formatting
If you use styled() in the "Formula" the color will display in the table, but not the form. If you use the new "Style" option the color will display in the form, but not the table.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Perso il colore sui campi formula
Ho appena controllato la versione per iPad, che non ho aggiornato, e sia la visualizzazione della tabella che la vista del modulo mostrano correttamente il colore.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: New formula field formatting
I just checked my iPad version, which I have not updated, and both table view and form view display the color correctly.
- Sean
- 6 yrs ago
- Get help
- Reported - view
New formula field formatting

Has anyone noticed any unwanted formatting changes of formula fields since the latest update. I have a database that I haven't worked with in a while so I can't remember if both the table view and…
- Sean
- 6 yrs ago
- 11replies
- 3924
- Get help
Re: Perso il colore sui campi formula
Non riesco a ricordare se sia la tabella che il modulo hanno visualizzato il campo della formula a colori prima dell'aggiornamento. Ora, solo la vista tabella mostra il campo a colori.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Perso il colore sui campi formula
Se sei aggiornato alla versione più recente di Ninox, questa potrebbe essere la ragione. Il campo formula è stato migliorato con nuove funzionalità di formattazione.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
🙄 It was a joke that played off of my comment about not pressing the Esc key. You are familiar with memes, right?
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
I see what Nick is saying now and it seems kind of pointless to back out of a screen that is showing a record to a screen that shows nothing. The Ninox team could easily catch this behavior and…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
Backup = back out of. 😬
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Form disappears with Escape key
Hi Nick, I’m only speaking in general here... Usually, the Esc key implements a way to backup or cancel a process so that might be the case with Ninox.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Help with loop!
You don't need to code a loop. Something like this will work... count(select YourTable where chosen(YourField, Multiple Choice Index Number)) Example: count(select Table1 where chosen(MC, 2)) https:…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How do I define the 'Number format' as 'Fraction Number' in a number field?
geral, if you want a starting point this might help. This code goes into a formula field... let myNum := format(Number, "#,###.##0");let decLoc := index(myNum, ".…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How do I define the 'Number format' as 'Fraction Number' in a number field?
In my previous post I assumed you wanted to use ¼ instead of .25
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: filling an appointment field
You could put this in the Trigger after update of the 'end date' field... YourAppointment := appointment('start date', 'end date')
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Syntax for "View" element
It can be helpful to breakdown each action into its own formula field. I don't think the line let x := split('Herbs in formula', ","); has the result you are looking for.…
- Sean
- 6 yrs ago
- Get help
- Reported - view

1 55 56 57 58 59 71

Welcome to the Ninox community

Sean

Re: How can I copy from a text field to a date field?

Re: How can I copy from a text field to a date field?

Re: How can I copy from a text field to a date field?

Re: New formula field formatting

Re: Coding for Buttons

Re: New formula field formatting

Re: New formula field formatting

Re: New formula field formatting

Re: New formula field formatting

Re: Perso il colore sui campi formula

Re: New formula field formatting

New formula field formatting

Re: Perso il colore sui campi formula

Re: Perso il colore sui campi formula

Re: Form disappears with Escape key

Re: Form disappears with Escape key

Re: Form disappears with Escape key

Re: Form disappears with Escape key

Re: Form disappears with Escape key

Re: Help with loop!

Re: How do I define the 'Number format' as 'Fraction Number' in a number field?

Re: How do I define the 'Number format' as 'Fraction Number' in a number field?

Re: filling an appointment field

Re: Syntax for "View" element

Overview