Fred

San Francisco, USA

3404
539
4

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

My Posts

Latest Posts

Re: How to get passed time in months from two dates?
Cause I can't leave well enough alone. The code can be cleaned up to: let sYear := year(Date1); let eYear := year(Date2); let numYear := if eYear > sYear then eYear - sYear else 0 end; let sMon :…
- Fred
- 1 yr ago
- 2
- Get help
- Reported - view
Re: How to get passed time in months from two dates?
Here is one way. Not as clean as Excel but it works: let sYear := year(Date1); let eYear := year(Date2); let numYear := if eYear > sYear then eYear - sYear else 1 end; let sMon := month(Date1);…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Calculating hours from Appointment
May I recommend another way. You can use the ceil() command. It would look something like: let x := number(duration(Appointment) / 3600000); ceil(x) In Ninox, time is kept in milliseconds.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Dynamic Reports - my first attempt
It seems to take the server about 3 - 8 minutes to create a test print of 1 record. The fewer the records in the table the faster the test print of only 1 record.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports - my first attempt
@Mel Charles I tried updating a template and it gave me an error. So it looks like there could be some issues with v3.9.
- Fred
- 1 yr ago
- Get help
- Reported - view
v3.9 is now live

In typical Ninox communication history, v3.9 is now live on the cloud. Just happen to notice as I'm trying to reduce my storage usage from backups. Maybe we will hear what is new.
- Fred
- updated 1 yr ago
- 7replies
- 154
- Learn and share
Re: Dynamic Reports - my first attempt
You got me interested in trying dynamic printing and created a file with: {d.Country} And I got: test1 The docs don't talk about how to handle spaces in names. Or is it saying that you can't.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: add onselect event for view field
@Jacques TUR that makes a lot of sense. thanks, Jacques
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Display fields from a linked record
@Julien When you get a chance, please mark this post answered.
- Fred
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Interesting scripting problem?
Here is a mock up of the N:N table idea.
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view

1 60 61 62 63 64 137

Welcome to the Ninox community

Fred

My Posts

Re: How to get passed time in months from two dates?

Re: How to get passed time in months from two dates?

Re: Calculating hours from Appointment

Re: Dynamic Reports - my first attempt

Re: Dynamic Reports - my first attempt

Re: Dynamic Reports - my first attempt

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?

Overview