Sean

1762
79
0

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

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Incrementing date in a script
If you want to increment a date by a week, you can just add 7 to the date or some multiple of 7 and I would use a Number field instead of a Time interval field.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Question
You can change the formula to get the last record where the field you are wanting to autofill isn't null. number(last(select YourTable where YourAutoFillField != null).Id)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Code Snippets Manager/Organizer - Any Preferences?
Karen, Are you wanting to organize Ninox code or some other language code? For Ninox, I try to organize my test databases by topic and put a "z" in front of the name to separate them from my working…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Best way to show "Created By", Modified By", "Created On" and "Modified On" on Forms and Views?
That's a good question, but not one I can answer. I assumed the calculation was processed when a record received focus.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Best way to show "Created By", Modified By", "Created On" and "Modified On" on Forms and Views?
It's kind of wonky, but you can use the 'Created by', 'Modified by', etc in a Formula field. If I displayed those columns before I created the formula fields, I would get a "Circular reference" error.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Adding time to date
You would use the datetime() function instead of the date() function. I've been learning Regex and Ninox has some Regex functions that allow you to parse text values.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: "This formula may not change the data."
@Eric Plet, I still can't combine create and open, but if I click on the Image field it will open the text file I created. You could at least delete the Formula field that you use to open the file.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: "This formula may not change the data."
@alejako, The "Formula" section can't modify data, but the "On click" section can. @Eric Plet, I couldn't get both to work in a single script. Even if I put the create code in the "On click" section…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: If statement not running
@aussiemckenna, I don't want to hijack your thread. If you're still having problems let us know. @Steven, It's frustrating that so little effort is put into keeping the documentation up-to-date.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: "This formula may not change the data."
I'm kind of confused by what you have posted... 1) You have 'File XSPF' := createTextFile(this, 'Code XSPF', Name + ".xspf") and the following line says that 'File XSPF' is a Formula field.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: If statement not running
I'm correcting myself... there is a string() function. Another undocumented function in the Ninox manual! How hard can it be to update your bare-bones manual?!?!
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Poll: are you using the visual or the text editor in formula editing?
@Karen
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: I want add 3 months future date with click of button.
DT is defined before the loop and won't update the way you have it. You can put... DT := date(YR, MO, DY) after MO := MO + 1 in the loop and it should work.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: If statement not running
As far as I know there isn't a string() function. Try this... let compare1 := text(deepDiveRecord.Pair) and then do the comparison. I'm fairly confident you are comparing an object to something that…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how to change the type of a field
Hi Christian, Nioxus is a Ninox partner and not the developer. I think the name is unfortunate, but it used to be worse, Ninoxus, and probably created quite a bit of confusion.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how to change the type of a field
LOL, I just found out the programming section of the Nioxus manual requires a paid subscription. I never use it, but the last time I checked it out it was free.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how to change the type of a field
Pete, I have some previous programming experience... I thought you did too. It's all pretty much the same except for the syntax, a loop is a loop and a conditional is a conditional.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: how to change the type of a field
Hi Pete, here is a solution... let myYear := number("20" + substr(YourTextDateField, 6)); let myMonth := number(substr(YourTextDateField, 0, 2)); let myDay := number(substr(YourTextDateField, 3, 2));…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Copy text value of local field to a linked field
I meant to say "like field values" not names.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Copy text value of local field to a linked field
Your posts appear to suggest two different scenarios. If you want to link records based on like field names then take a look at this... https://ninoxdb.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to use in a formula a value of a specific record from a separate table
Hi, try this... record(YourTable, 1).'Second_product_discount_var' You might find this helpful, also...…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Converting min/mile
Pete, You're welcome. I really enjoy coding in Ninox and I think it's easy to be productive quickly with the scripting language. Yes, variables can be declared as you go but they do have scope.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Converting min/mile
Hi Pete, I think I've gotten the kinks worked out. This takes the time from a Text field and mine is named TextTime. You can use a different field name,…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Converting min/mile
Which field type are you using for the raw time data?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Converting min/mile
I see there are issues with my formula and that is partly due to the inconsistent treatment of the TimeInterval field. If I use the "3867.37m" Number format for the TimeInterval field,…
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 40 41 42 43 44 71

Welcome to the Ninox community

Sean

My Posts

Re: Incrementing date in a script

Re: Question

Re: Code Snippets Manager/Organizer - Any Preferences?

Re: Best way to show "Created By", Modified By", "Created On" and "Modified On" on Forms and Views?

Re: Best way to show "Created By", Modified By", "Created On" and "Modified On" on Forms and Views?

Re: Adding time to date

Re: "This formula may not change the data."

Re: "This formula may not change the data."

Re: If statement not running

Re: "This formula may not change the data."

Re: If statement not running

Re: Poll: are you using the visual or the text editor in formula editing?

Re: I want add 3 months future date with click of button.

Re: If statement not running

Re: how to change the type of a field

Re: how to change the type of a field

Re: how to change the type of a field

Re: how to change the type of a field

Re: Copy text value of local field to a linked field

Re: Copy text value of local field to a linked field

Re: How to use in a formula a value of a specific record from a separate table

Re: Converting min/mile

Re: Converting min/mile

Re: Converting min/mile

Re: Converting min/mile

Overview