Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Replace array of items
I'm not sure what you are asking exactly but here is one option. let myText := 'Text 2'; let array := chosen(MC); for loop1 in array do myText := replace(myText, loop1, "BOB") end;…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Timed scripts
@S Moore When you get a moment can you describe your setup for the rest of us? Are you using the free version of dockers? I’m looking for an affordable API setup.…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Spinning wheels
I just encountered something similar, but slightly different. A table that use to load fine, but has suddenly slowed down. This time there were no major changes to the table structure.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: About the side-column width adjustment in the fx window
i do this all the time with my poor memory.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Avoid spaces in a sum function when a variable is empty/void
Love the community engagement. By the way you can also take my suggestion and add it to your original code. :) let x := original code; replacex(x, "\s{2,}", " ")
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Avoid spaces in a sum function when a variable is empty/void
I'm sure there is a way to figure out how not to put in empty fields, but here is a regex way of doing it. You can create a formula field and put this in: replacex(originalformulafield, "\s{2,}",…
- Fred
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: How To View a subtable from a different Table
Take a look at the Writable if part of the Edit Table window. You can create a table, maybe call it Security, and use that to organize users into groups.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Auto link to N:2 root table
@Julien said: To be clear, my first purpose is to track lenght of rotations at a post rather than people. To be clear you have a 1:N between Company and Function,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Display fields from a linked record
@Julien When you get a chance, please mark this post answered.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to Get Triggers to Work when Importing Records?
@Dave Irving said: so no way to create a server side script to run triggers upon an import? I guess there isn't, or Ninox would allow triggers to run on import.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Interesting scripting problem?
Here is a mock up of the N:N table idea.
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Interesting scripting problem?
Here is a simple solution: let t := this; let x := (select Employee where contains(numbers(Tasks), number(t))); concat(x.Name) Since you use a dynamic multichoice (dMC) field you have to use a select…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: JSON: add a block based on a given condition
Have you seen this post?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to Get Triggers to Work when Importing Records?
You may want to consider putting your trigger codes wrapped in a for loop in a button. That way you only have to press a button.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Display fields from a linked record
You use the reference field name. By default Ninox uses the table name for the reference field, so if you have a Table1 and Table2 and create a reference field in Table2 to Table1 then in Table2 you…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Auto link to N:2 root table
Just my two cents, but it seems like there should be a direct link between Company and Contacts then a N:N link between the two called Function. This way you can track specific data for that person…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Using a Dynamic multiple choice field to filter a dynamic choice list
@Javier Gómez Great to hear. Please remember to mark the post answered when you get a chance.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Using a Dynamic multiple choice field to filter a dynamic choice list
Are you creating these dMC fields in a third table, most likely a dashboard? Is country in tHotels a dC field?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Using a Dynamic multiple choice field to filter a dynamic choice list
Yeah, when you tell Ninox to check a contains of an array in another array it will not iterate through the choice array. It will just look to see if all of the numbers in the array appear in the…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Rant: More Server Issues
Looks like things may have cleared up. Late last night (about 11pm PST), there were 8 processes still running. This morning there are none so I made a change and it was saved. Only lost the weekend.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Rant: More Server Issues

Sadly, again I lost my ability to work on my DB last night. Again on a Friday. I can't save any work. The app says I have 6 background processes going and it has been that way for hours now.…
- Fred
- updated 2 yrs ago
- 2replies
- 89
- Learn and share
Re: Comments???
Here is@Jacques TUR 's excellent background on the use of #{}# as a comment delimiter.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Dynamic combobox/dropdown list
@Kruna I don't do any printing, so I can't help you out there. Printing, in my opinion, is still a weak point of Ninox.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Dynamic combobox/dropdown list
@Kruna said: Is there a way to get the choices sort by 1.group and then by 2.abc? Ninox can not do a multilevel sort with code commands. You have to create another field that combines the two fields…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: creating linked records from table A to tables B and C question
@Roger you are correct. sorry, I thought you were to original poster.
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 76 77 78 79 80 152

Welcome to the Ninox community

Fred

Re: Replace array of items

Re: Timed scripts

Re: Spinning wheels

Re: About the side-column width adjustment in the fx window

Re: Avoid spaces in a sum function when a variable is empty/void

Re: Avoid spaces in a sum function when a variable is empty/void

Re: How To View a subtable from a different Table

Re: Auto link to N:2 root table

Re: Display fields from a linked record

Re: How to Get Triggers to Work when Importing Records?

Re: Interesting scripting problem?

Re: Interesting scripting problem?

Re: JSON: add a block based on a given condition

Re: How to Get Triggers to Work when Importing Records?

Re: Display fields from a linked record

Re: Auto link to N:2 root table

Re: Using a Dynamic multiple choice field to filter a dynamic choice list

Re: Using a Dynamic multiple choice field to filter a dynamic choice list

Re: Using a Dynamic multiple choice field to filter a dynamic choice list

Re: Rant: More Server Issues

Re: Comments???

Re: Dynamic combobox/dropdown list

Re: Dynamic combobox/dropdown list

Re: creating linked records from table A to tables B and C question

Overview