John Halls

John_Halls

Somerset, England

Joined: Thu Feb 11 10:04:26 UTC 2021

My Posts

Latest Posts

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
- 3 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
- 3 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
- 3 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
- 3 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 3 yrs ago
- Get help
- Reported - view
Re: Conditional Formatting Built into Formula Field
These two formula fields have the same formula!
- John_Halls
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view

1 27 28 29 30 31 32 33

Welcome to the Ninox community

John Halls

My Posts

Re: Help with last Formula...

Re: Help with last Formula...

Re: Help with last Formula...

Re: Sum a customer sale in a view

Re: Sum a customer sale in a view

Re: Limit field value based on another field

Re: Limit field value based on another field

Re: Dependant Table Actions

Re: Dependant Table Actions

Re: Query Help for a VIEW. Unexpected behavior.

Re: To copy a formula field in a formula text ?

Re: To copy a formula field in a formula text ?

Re: To copy a formula field in a formula text ?

Re: Bundled Product Circular Reference

Re: Bundled Product Circular Reference

Re: Remove empty KANBAN

Re: Bigger or equal…

Re: Bigger or equal…

Re: Bigger or equal…

Re: Bigger or equal…

Re: Conditional Formatting Built into Formula Field

Re: Bigger or equal…

Re: Conditional Formatting Built into Formula Field

Re: Conditional Formatting Built into Formula Field

Re: Conditional Formatting Built into Formula Field

Overview