John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
- 4 yrs ago
- Get help
- Reported - view
Re: To copy a formula field in a formula text ?
Yes, well done! Did it work?
- John_Halls
- 4 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
- 4 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
- 4 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
- 4 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 4 yrs ago
- Get help
- Reported - view
Re: Conditional Formatting Built into Formula Field
These two formula fields have the same formula!
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 4 yrs ago
- Get help
- Reported - view

1 28 29 30 31 32 33 34

Welcome to the Ninox community

John Halls

My Posts

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

Re: Bigger or equal…

Re: adding many record references

Re: Consistency check formula

Re: adding many record references

Re: Join on non-key field to update records

Re: Join on non-key field to update records

Re: TRIGGER problem - Help please!

Re: problems with view

Re: problems with view

Overview