Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3736
592
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel said: It does process the Attendance_Staging table, but only the last record is saved. I tested it out with just the contacts part and it created the two records (Lynn and Jeff) that are…
Fred
Fred
2 mths ago
1
Get help
Reported - view
Re: Can I control the order in which Ninox displays my tables?
Have you tried @Jacques TUR ChatGPT? It is better than the general version, but still not perfect.
Fred
Fred
2 mths ago
1
Get help
Reported - view
Re: Need a formula between week to place on (%Semana Plan)
maybe something like: let t := this; let prevRec := (select TalbeName where Week = (t.Week-1)); 'Progress Plan' - prevRec.'Progress Plan'
Fred
Fred
2 mths ago
Get help
Reported - view
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
Fred
2 mths 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 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
Fred
3 mths ago
Get help
Reported - view
1
3
4
5
6
7
150
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
View all topics
