Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Excel scripting with carbone
@frsalabert said: I would like to collect in an excel file the complet list of my different Navire.Options Just to clarify that Ninox can only output into PDF through dynamic printing.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel Can you copy your DB and remove all personal data and put in fake data?
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Fields for Form use, not needed in "record"
@Graham Brown said: So my question is, how do I reduce record size when creating non-essential fields on the one and only form per table? A couple of extra fields are not really going to "explode"…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel That looks great! You are on your way. I know it seems like too much extra work, but you will soon find that going into the tables directly to be too much trouble and wished you had…
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Problem in my DB WorkOrder
@Rafael Also start your scripts just doing the basics, make a new record and then link to proper records. Once all that works then you can add in the field updates.
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel You probably have all the knowledge already to setup your dashboards. If you uses Pages then all you need is to create the fields that make up the UI. No special training needed.
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel it took me awhile to understand the advantages of dashboards. I’m the only user but even for me I’m finding them helpful. Plus I don’t trust myself. 🤣
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel off the top of my head, dashboards/pages can: 1) data validation before you write the data to a record 2) you make an easy UI for your users 3) simpler data access protection,…
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: [Bug] Formula "image" field not showing content in Cards view
I'm on public cloud so I don't have modularity, yet. Maybe by fall, public cloud will have modularity.
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Problem in my DB WorkOrder
Have you considered making Progress Reports a child of Cutoff Days? Since you want to make a report for each record in Cutoff days. So you only need to link the progress report record to a Cutoff…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Problem in my DB WorkOrder
@Rafael Always try to minimize your use of selects. So your for loop on line 6 can use the reference field 'CutOff days' instead of the select. I'm not sure why you use the select on line 5 as well.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Problem in my DB WorkOrder
@Rafael You have cutoff dates linked to ENG WORKORDERS so use that reference link in your for loop.
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Problem in my DB WorkOrder
Looking at the buttons again, you fixed the Calculate dates button. It links the cutoff date records to the ENG WORKORDERS record correctly. Now just repeat it in the Create Progress Report button.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@John Halls sadly, I'm my only user and I have to keep myself from doing stupid things.
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Problem in my DB WorkOrder
I think you do know how to solve the issue, but sometimes the solution is slipped our minds. Remember that when you use the create() command, all it does is create a new blank record.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Create a view based on contains
@Sotirios Zormpas The chosen() path finds records that have the exact same selection (all records that have choice 1,2&4). Not all records that contain any of those selections.
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Create a view based on contains
@Sotirios Zormpas Thanks for the reminder. I forgot that chosen() is pretty powerful. In fact it would make the comparison of two arrays so much simpler.…
- Fred
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
I would recommend that you don’t allow users to navigate the tables directly. Create dashboards that allow users to do what they need to do. Can never trust those users to do what they are supposed…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Passing a field name (string) as a function parameter
Have you tried the set() command? It is made for using text reference of fieldnames. function updateField(iField:text, iValue:text, iRecord: number) do let me := record(Products,iRecord); set(me,…
- Fred
- 4 mths ago
- 3
- Get help
- Reported - view
Re: Create a view based on contains
@Leo Woer Now that we are trying to compare two arrays (one from Guidance and one in your other table) we need to do some extra work. You can learn more from this post that @Jacques TUR shared.…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: Create a view based on contains
You can try: let Xngl := lower('keyword selection'); select Guidance [contains(lower(text(keywords)), Xngl)] Since you are allowing users to type in their own words in 'keyword selection,…
- Fred
- 4 mths ago
- Get help
- Reported - view
Re: When to create a child/sub table.
@Mel Charles LOL😂😂😂. That is also a very good choice.
- Fred
- 4 mths ago
- Learn and share
- Reported - view
Re: When to create a child/sub table.
@Mel Charles Maybe create a "new" production table with the new format. Leave the old stuff alone, and just move forward with the new. It will mean modifying print layouts but better than creating…
- Fred
- 4 mths ago
- Learn and share
- Reported - view
When to create a child/sub table.

It has been mentioned in this forum about when to create a child/sub table. One way is if you find your self adding a prefix or suffix to your fields that store similar data.…
- Fred
- updated 4 mths ago
- 4replies
- 85
- Learn and share
Re: 1 to N table had values removed
@BuffaloTony said: The one thing I might lose is my scheduling view that you helped me code with JS and HTML You won't lose this. You just have redirect the source of the data from the dynamic field…
- Fred
- 4 mths ago
- Get help
- Reported - view

1 5 6 7 8 9 152

Welcome to the Ninox community

Fred

Re: Excel scripting with carbone

Re: Can I control the order in which Ninox displays my tables?

Re: Fields for Form use, not needed in "record"

Re: Can I control the order in which Ninox displays my tables?

Re: Problem in my DB WorkOrder

Re: Can I control the order in which Ninox displays my tables?

Re: Can I control the order in which Ninox displays my tables?

Re: Can I control the order in which Ninox displays my tables?

Re: [Bug] Formula "image" field not showing content in Cards view

Re: Problem in my DB WorkOrder

Re: Problem in my DB WorkOrder

Re: Problem in my DB WorkOrder

Re: Problem in my DB WorkOrder

Re: Can I control the order in which Ninox displays my tables?

Re: Problem in my DB WorkOrder

Re: Create a view based on contains

Re: Create a view based on contains

Re: Can I control the order in which Ninox displays my tables?

Re: Passing a field name (string) as a function parameter

Re: Create a view based on contains

Re: Create a view based on contains

Re: When to create a child/sub table.

Re: When to create a child/sub table.

Re: 1 to N table had values removed

Overview