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
John Halls
John_Halls
Somerset, England
812
137
1
Joined: Thu Feb 11 10:04:26 UTC 2021
Follow
My Posts
Latest Posts
Re: Bundled Product Circular Reference
Hi kanepow This requires a many to many relationship. An example of this would be students and classes. A student attends many classes and a class has many students.…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Remove empty KANBAN
Your Kanban should be based on a choice field. Click on Edit fields... and then this choice field and set Required to Yes Regards John
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Bigger or equal…
My code goes in a button not a formula field. isDuplicate is a text field. Lots of little miastakes in your code like a space between b, and 'Premier mot' and a missing single quote at the end on the…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Bigger or equal…
Hi Your previous method used a formula field to calculate if the record is duplicate or not. My method uses a text field to caputure whether your record is duplicate or not and you can call your new…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Bigger or equal…
If you text field is called isDuplicate then this will work let a := "";for b in (select 'Oiseaux famille genres espéces') order by 'Premier mot' do if a = b.'Premier mot' then b.…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Bigger or equal…
Hi All I'm not so sure about having select statements in a formula field and what the conditions are that trigger them to be re-evaluated. It could be that on first creating the formula field and…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Conditional Formatting Built into Formula Field
Hi All When it comes to colouring a field according to its valuse I thought I would put something together that is more re-useable and have come up with the following let numberField := Number;…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Bigger or equal…
Hi Can you copy and paste your final code here. Thanks John
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Conditional Formatting Built into Formula Field
These two formula fields have the same formula!
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Conditional Formatting Built into Formula Field
Hi Nick That's wierd. I took a random table in my sandpit database and added a number and formula field, it displayed OK in form view but I had no joy whatsoever in table view.…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Conditional Formatting Built into Formula Field
Sorry, I'm stumped! I can get the styled and color functions to work in form view but not in table view. All it shows is an unformatted 0. Is this correct?…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Bigger or equal…
You have >=1 so the result is true for every record. Try >1 instead. Regards John
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: adding many record references
Ah Sean you are right I took it from the manual which gives the example for p in (select Person)p.Haircolor := "red" and thought there were two forms, one that looped through one by one and another…
John Halls
John_Halls
4 yrs ago
1
Get help
Reported - view
Re: Consistency check formula
How about if abs('Total Direct Costs (IC)' + 'Total HQ Costs (IC)' - 'Total Activity-Related Budget (IC)') <= .01 then "Consistent"else "Not consistent"end abs(x) takes the absolute value of x.…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: adding many record references
Lovely progression to some succinct code Sean for oneRec in select OneTable dofor manyRec in select ManyTable where Text = oneRec.Text domanyRec.(OneTable := oneRec.…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Join on non-key field to update records
Hi If your Item Code is called Ref, and quanitiy called Qty in both your Products and Import tables and you have a flag called Flag that notes new imports vs previous imports then this code will loop…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Join on non-key field to update records
Hi When you talk about the parent system, you mean a system outside of Ninox, and that this has it's own set of IDs. Does the Import table just hold the latest import,…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: TRIGGER problem - Help please!
Hi Anna Didn't we answer this question a week ago? Regards John
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: problems with view
Hi Henrik If its hidden with the Hiiden attribute of the table ticked then you can untick that to show thae table again, or if it's not showing because Compsition is set to Yes it can be accessed…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: problems with view
Morning Henrik From my structure you can view the Activity as a Kanban or as a Pivot (not so successfully). In each of these you need to include the yearweek field so that you can search for it.…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: problems with view
Hi Henrik I have mocked up something that gives what you describe. You will need to use a Kanban view and counter intuitively this is in the Activities table, not horses.…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Counting the number of
Hi Alain i don't know if I am right but I have noticed that select statements at the formula field level don't always get updated for every record when looking at a list I saw this in the running…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Table records user control
In addition The Readable if also relates to the child tables if Compsition is set to Yes but if Composition is set to No the children of a non-readable parent remain visible,…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Table records user control
Hi Carlos this is an easy and powerful feature of Ninox. In Edit fields... do you see Readable if in the lower left had side. If there is a formula placed there it has to evaluate to true for the…
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
Re: Counting the number of
Alain that is amazing. I'm learning something new every day!
John Halls
John_Halls
4 yrs ago
Get help
Reported - view
1
27
28
29
30
31
32
33
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
Usage overview
Process monitor
View all topics