Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
John Halls
John_Halls
Somerset, England
603
72
1
Joined: Thu Feb 11 10:04:26 UTC 2021
Follow
My Posts
Latest Posts
Re: Roles on owner
The owner only has the role admin. Try using a global function such as function userMyRole(role : text) douserHasRole(role) or userHasRole("admin")end This mimics the userHasRole function but giving…
John Halls
John_Halls
2 yrs ago
Get help
Reported - view
Re: Help with last Formula...
Looking again at the code, as you are quizzing the Invoices table (not the relationship) you need to include the word select in your statement, and your screenshot shows the customer relationship as…
John Halls
John_Halls
2 yrs ago
Get help
Reported - view
Re: Help with last Formula...
Can you post a copy of the code you used in the view. We can use that as the basis for your code to sum values.
John Halls
John_Halls
2 yrs ago
Get help
Reported - view
Re: Help with last Formula...
Hi Michael I didn't realise you were using a dashboard. I can't see why Nick's code is not working. Are you getting an error when you type the code into the formula or is it 'working' but producing…
John Halls
John_Halls
2 yrs ago
Get help
Reported - view
Re: Help with last Formula...
Hi Michael Didn't I answer this a couple of days ago? --- You haven't said what your link from Customer to Invoices is called, but say it is called Invoices try this formula sum( Invoices['Date of…
John Halls
John_Halls
2 yrs ago
Get help
Reported - view
Re: Sum a customer sale in a view
Hi Michael You haven't said what your link from Customer to Invoices is called, but say it is called Invoices try this formula sum( Invoices['Date of Invoice'>= xBeg and 'Date of Invoice' <=xEnd].…
John Halls
John_Halls
2 yrs ago
Get help
Reported - view
Re: Sum a customer sale in a view
Hi Michael I can put something together later on today. From your Customer table, can you let me have the name of the relationship to your Invoices table (it might also be called Invoices).…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Limit field value based on another field
I failed to mention, it goes here Regards John
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Limit field value based on another field
Hi If your data model loks like this Than add a constraint in the pyaments relation to Provider like this Regards John
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Dependant Table Actions
Hi Andrew If your relationship field is called fromTableD and the Active / Not Active fleld in TableD is called Status then you can use let curRec := this;…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Dependant Table Actions
Hi Andrew Let's leave No 1 to last 2. Create a record in TableA, put this in the Trigger on create let curRec := this; for xTableB in select TableB do let xCreate := (create TableC); xCreate.…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Query Help for a VIEW. Unexpected behavior.
As you have a relationship there is no need to use the select statement, also there's no need for two if statements and lastly I think your boolean test uses two 'or' elements and this might be the…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: To copy a formula field in a formula text ?
Yes, well done! Did it work?
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: To copy a formula field in a formula text ?
Yes, what I was trying to get you to think about was:- from this code how are you going to fill your empy field 'Prem mot'? It is not mentioned in the code, so where do you think it should go?
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: To copy a formula field in a formula text ?
Steven told you Note: do not translate the code, only the names of your table and the required fields. And you said what table and fields you needed to use here 'Oiseaux famille genres espéces' is…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
Re: Bundled Product Circular Reference
Hi Alain Just read you linked post and you are so right. I have assumed in this case there is just a single level. I started to answer a more complex post a few weeks ago and said I'd get back with a…
John Halls
John_Halls
3 yrs ago
Get help
Reported - view
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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 yrs ago
Get help
Reported - view
1
19
20
21
22
23
24
25
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics