Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

741
115
1

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

My Posts

Latest Posts

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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Counting the number of
Alain that is amazing. I'm learning something new every day!
- John_Halls
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Parent - Child Record Update Example. Code Help to Complete Needed.
- John_Halls
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Learn & 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
- 3 yrs ago
- Get help
- Reported - view

1 24 25 26 27 28 29 30

Back to top

Ninox-Documentation

Overview

View all topics