John Halls's Profile | Ninox community

Badges

Latest Posts

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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Hi Can you copy and paste your final code here. Thanks John
- John_Halls
- 5 yrs ago
- Get help
- Reported - view
Re: Conditional Formatting Built into Formula Field
These two formula fields have the same formula!
- John_Halls
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 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
- 5 yrs ago
- Get help
- Reported - view
Re: Counting the number of
Alain that is amazing. I'm learning something new every day!
- John_Halls
- 5 yrs ago
- Get help
- Reported - view
Re: Counting the number of
Sorry Fred. We ovelapped and I hadn't seen your reply. Do you know if you can use a where clause through the relationship? I experimented but couldn't get anything to work. Regards John
- John_Halls
- 5 yrs ago
- Get help
- Reported - view
Re: Counting the number of
Hi If there is a reationship between two tables you can use aggregate functions in the onesuch a cnt, sum, max, etc on the many. So to find the count of tasks in a job create a formula field and put…
- John_Halls
- 5 yrs ago
- Get help
- Reported - view

1 31 32 33 34 35 36 37

Welcome to the Ninox community

John Halls

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

Re: problems with view

Re: Counting the number of

Re: Table records user control

Re: Table records user control

Re: Counting the number of

Re: Counting the number of

Re: Counting the number of

Overview