Fred

San Francisco, USA

3683
590
5

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

My Posts

Latest Posts

Re: Excel scripting with carbone
In Carbone you place the repetition code at the level where you need to repeat. So the first column code would look like: {d.Offres.Options[i].Quantité} {d.Offres.Options[i+1].…
- Fred
- 1 mth ago
- Get help
- Reported - view
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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- Get help
- Reported - view
Re: When to create a child/sub table.
@Mel Charles LOL. That is also a very good choice.
- Fred
- 1 mth 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
- 1 mth 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 1 mth ago
- 4replies
- 62
- Learn and share

1 2 3 4 5 148

Welcome to the Ninox community

Fred

My Posts

Re: Excel scripting with carbone

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.

Overview