John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Missing Post
Hi Maria Thank you. This was a follow-up to the original post. The original would have been dated 31st March or 1st April. Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Hi, How do I check if the current Year has changed?( I want to reset a counter on the first record of the new year)
Count the number of projects created this year, and add that to a base number let a := cnt(select Projects where year('Created on') = year(today()));'P#' := 999 + a Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Hi, How do I check if the current Year has changed?( I want to reset a counter on the first record of the new year)
Hi Fred and Rocco The problem here is that if you put this in a Trigger on create then LDate will always equal Today(). Trigger on create includes the record that has just been created. Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Progressive sum
This doesn't refresh as numbers in A change, so try making B a number and put this in the Trigger after update let a := 0;for j in (select Months) order by Order do a := a + j.A; j.(B := a)end
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Progressive sum
I got this to work I made a table with 12 records with the fields Month Text Order Number A Number B Formula B contains the following formula let a := Order;sum((select Months where Order <= a).…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Help, my code is half-working...what's wrong?
Hi Anna You need to change each if 'Courier Type' = 1 then 'Courier Charge' := 29.99 and ('Insurance Value' := 1) To if 'Courier Type' = 1 then 'Courier Charge' := 29.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Logical syntax for multiple "if" choice
Try this let a := date(2019, 1, 1);let b := date(2019, 12, 31);if 'Start date' = null or 'End date' = null or 'Start date' > b or 'End date' < a then 0else let c := max('Start date', a); let d :…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Logical syntax for multiple "if" choice
Hi Giovanni This is what the manual says if Age < 18 then if Age < 13 then "Child" else "Teenager"else "Grown-up"end Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way to keep certain users from seeing some records in a database
Hi Joe and Brendon Yes this is achieved by going to the table you need to scope. Use the Readable if function on the left hand side. You can put in there things like 'Created by' = user() to only…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Concatenate for sum
You are misunderstanding the manual. Concatenate is just one of the options available to show at the bottom of the columns in a list view. You are not seeing the options of Sum, Average, Min,…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Recipe as an ingredient entry for other recipes
Thanks Jeff. One table is the way to go. I'm tied up today but will come back with some ideas as soon as I can. Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
I would use a Reset button but first you need to update the Trigger after update so that this allows the Reset button to work if OldStatus = 1 and Status = 2 then OldStatus := Status; let v := this;…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
Re the Empty column, in the Status field change Required to Yes. More coming re the rest...
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
Hi You need an extra right hand bracket in the line above, so it becomes t.(In := datetime(now())); But you don't need the datetime function. just use t.(In := now()); Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
In addition to this The Volunteer Trigger on create needs Status := "Not Working";OldStatus := "Not Working" The second relationship CurrentTimesheetID is the other way round to TimesheetID,…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
Hi I have put a version together. I have added an OldStatus exactly as Status to track where the card has come from, and another Reference filed that just holds the current timesheet.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Short Contributors Bio
Thank you I run my own business and have used my own programs to help with invoicing, stock control, costing, production, tracability, etc. Over the years I've used Basic, dBase II, Foxpro,…
- John_Halls
- 4 yrs ago
- Learn and share
- Reported - view
Re: Creating a dependent Child record. Use of 'this' statement.
Alain is right. It's easy to confuse Timesheet the Table and Timesheet the reference field. I tend to rename mine so I'd have TimesheetIDs in Volunteer and VolunteerID in Timesheet.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Creating a dependent Child record. Use of 'this' statement.
Hi Yes, I've answered this once... Change let v := this.Id; to let v := this; If your relationship field in Timesheet is called Volunteer Change t.(Id := v) to t.(Volunteer := v) Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Missing Post

Very odd... I just replied to someone looking for help to create a child timesheet entry, and the post has disappeared. Regards John
- John_Halls
- 4 yrs ago
- 3replies
- 295
- Get help
Re: Button Code Help Please
Sorry, thats Location:= 0
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Button Code Help Please
Location = 0 Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view

1 27 28 29 30 31 32 33

Welcome to the Ninox community

John Halls

My Posts

Re: Counting the number of

Re: Counting the number of

Re: Missing Post

Re: Hi, How do I check if the current Year has changed?( I want to reset a counter on the first record of the new year)

Re: Hi, How do I check if the current Year has changed?( I want to reset a counter on the first record of the new year)

Re: Progressive sum

Re: Progressive sum

Re: Help, my code is half-working...what's wrong?

Re: Logical syntax for multiple "if" choice

Re: Logical syntax for multiple "if" choice

Re: Is there a way to keep certain users from seeing some records in a database

Re: Concatenate for sum

Re: Recipe as an ingredient entry for other recipes

Re: Parent - Child Record Update Example. Code Help to Complete Needed.

Re: Parent - Child Record Update Example. Code Help to Complete Needed.

Re: Parent - Child Record Update Example. Code Help to Complete Needed.

Re: Parent - Child Record Update Example. Code Help to Complete Needed.

Re: Parent - Child Record Update Example. Code Help to Complete Needed.

Re: Parent - Child Record Update Example. Code Help to Complete Needed.

Re: Short Contributors Bio

Re: Creating a dependent Child record. Use of 'this' statement.

Re: Creating a dependent Child record. Use of 'this' statement.

Missing Post

Re: Button Code Help Please

Re: Button Code Help Please

Overview