Fred

San Francisco, USA

3747
594
5

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: add onselect event for view field
@Jacques TUR that makes a lot of sense. thanks, Jacques
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
Hi all - Here is my setup. I have a dashboard, "All Horses Stats" that has a view element to a table called DashTemp. In DashTemp is a number field called HorseID.…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Ninext project
@Jacques TUR can you provide links to instructions again on how to copy the code to a text field?
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Display a maximum number of data
Sébastien Guillet said: I tried with rsort() but nothing worked. Yeah, you would think rsort() would take your sort order and reverse it, but it seems to reverse the record Id regardless of the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Display a maximum number of data
@Sébastien Guillet said: I know there is something like "order by" but I don't know where to put it in the formula. You would need to order the initial gather of data. let gatherData := (Compte.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to pop up a dialog if a record in a table meets a criteria.
@IFD Engineering Background on why you are getting the error message. When you changed line 1 to a count, variable z is now a simple number when it use store NID data.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Display a maximum number of data
@RoSoft_Steven beat me to it. again! Here is another option. @Sébastien Guillet said: I use a formula field to display text data which is itself from another formula field which contacts data.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
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

1 74 75 76 77 78 150

Welcome to the Ninox community

Fred

My Posts

Re: add onselect event for view field

Re: add onselect event for view field

Re: Ninext project

Re: Display a maximum number of data

Re: Display a maximum number of data

Re: How to pop up a dialog if a record in a table meets a criteria.

Re: Display a maximum number of data

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

Overview