Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

756
123
1

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

My Posts

Latest Posts

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 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
- 3 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
- 3 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
- 3 yrs ago
- 3replies
- 295
- Get help
Re: Button Code Help Please
Sorry, thats Location:= 0
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Button Code Help Please
Location = 0 Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Short Contributors Bio

Hi All I'm pretty new to this forum, and to Ninox. I see the same names contribute their knowledge to us all (thank you) and I wonder if they (you) would be willing to give a bit of background about…
- John_Halls
- 3 yrs ago
- 8replies
- 577
- Learn and share
Re: Moving Columns from Available Columns to Visible Columns
Hi Joan Doe it have > (greater than) symbol next to it? This means its a table not a field. Click on this to drill down into the fields. If this is a one to the many in tha view you will see symbols…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Importing fields with carriage returns
Hi Bill You aren't doing anything wrong. CSVs use commas to separate fields and carriage returns to separate records. What is the original source of your CSV?…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Create multiple records in a subtable?
Hi You are trying to define a function called setRow. There's no need. In very basic terms use this let myID := Id;let n := 5; Add more variables from Table A here for i in range(1, n) dolet NN :…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Recipe as an ingredient entry for other recipes
Hi Jeff I just want to check a few things:- 1. Do you have a table for 'Stock I Make' aand nother for 'Stock I Buy' OR do you have a single table for Stock (regardless of whether it's made or bought).…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Populating a field in one table with text value from another table
let a := Name;let b := first(select T2 where Name = a).LVLban;if b = null then "Not Found" else b end
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 25 26 27 28 29 30 31

Back to top

Ninox-Documentation

Overview

View all topics