John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: INVENTORY
Good luck! Any questions just ask.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: INVENTORY
Hi Jean-Philippe I posted a reply to a similar query a while ago. You may be able to adapt it to suit your needs.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger after change
Hi Bobo Are either of 'Orders available today' or AmazStars formula fields, calculated from fields in another table? Thanks John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Stuck on simple multiple if/else
Hi Robert Just a couple of tweaks. To use the text of a choice field in a formula you need to use text(Rating) and then as it's in a formula field just use the value without the equals sign.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger after change
Hi Bobo If the total is a formula field calculated from the sum of child records then it won't trigger if your Trigger after update: is on the parent. It has to be on the child,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Query - Vieuw
Hi Michel How many records do you have in each of the tables Contractor, Gebruiker and Registraties_Detail? Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Auto increment in subtable
Hi John The 1.5 trick gives it a temporary sort order value between the one above and the one above that, before all being re-assigned a new order value.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Merry Christmas to all my Fellow Ninox Forum Users
Merry Christmas one and all. I am looking forward to chatting to you all again in 2022. Happy dolidays! All the best - John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: How to see all items over certain value when another field is a 'yes'
It should, of course, be if insure = "yes" and value > 500 then "Yes" else "No" end Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: How to see all items over certain value when another field is a 'yes'
Hi Davie You are correct, create a new formula field with a formula something like this if insure = "yes" and value < 500 then "Yes" else "No" end Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Sort day field alphabetically, I want Monday, Tuesday, Wednesday...
Hi Mr K I encountered the same problem. I ended up prefixing my days with a number: 1-Monday, 2-Tuesday, etc Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: How to copy a row or just few collummns from one table to another using a button
You can give the Inventory recor a handle and then use it, such as let a:= this; let c := (create 'Delivery List');c.(Delivery_Field1 := a.Inventory_Field1);c.(Delivery_Field2 := a.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: product(array)
I'd be interested to ask what the use case is as I've never had to find the product of a large set of numbers. I imagine it won't be the speed if iteration that will be the problem but just how big…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
Well done. Come back anytime you have a query.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
A view is not a link, its an element you can add to your form. It takes a formula which returns a set of records. These can be related to the table the view is on,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Adding links to records in the child table on the form using a script.
Having more than one relationship between two tables can be a useful thing, for example a customer may have more than one contact associated with it, but one main contact and to have two…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: product(array)
Hi UKenGB The join function will turn an array into a string and you can choose how to concatenate this. If you choode "*" then the resulting text field can be evaluated.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to e-mail with record in PDF attached
Hi Martijn I tested some code based on your construction and it sent emails perfectly. In your code to send Invoices you have let a := (select RELATIONS where Id = xCust and 'E-MAIL INVOICES' = true);…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Change colour of a formula box if it’s a year later
Hi Nick I hope you don't mind but I would just have let t := days('Last Updated', today());if t > 365 thenstyled("Expired", "red")elsestyled("Not Expired", "green")end Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Seems basic math and date function are bugged
Hi Daniel Neither of the functions have bugs. Sorry to say I don't think your solution is correct. You problem was really quite hard to solve and it boils down to three elements. 1.…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Trigger on Update not triggering
Did you try swapping out duplicate for create? I think you will find duplicate is the source of the bug. I can show you my test code if you would to see it.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Initials
Thanks Alain. I would never have worked that out. Time to learn a bit about Regex...
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Initials
Thanks Alain I must have soent an hour trying to do that and could not for the life of me get to grips with it. Could you explain the regex expression and what the g and $1 are.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Initials
Hi Jan How about let w := "John F Kennedy";let i := ""for a in split(w," ") doi := i + substring(a,0,1)end;i Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger on Update not triggering
OK, after extensive testing I was able to mimic the behaviour you were experiencing (button vs trigger etc) and find the culprit. I have to concur that it's very odd.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 21 22 23 24 25 34

Welcome to the Ninox community

John Halls

My Posts

Re: INVENTORY

Re: INVENTORY

Re: Trigger after change

Re: Stuck on simple multiple if/else

Re: Trigger after change

Re: Query - Vieuw

Re: Auto increment in subtable

Re: Merry Christmas to all my Fellow Ninox Forum Users

Re: How to see all items over certain value when another field is a 'yes'

Re: How to see all items over certain value when another field is a 'yes'

Re: Sort day field alphabetically, I want Monday, Tuesday, Wednesday...

Re: How to copy a row or just few collummns from one table to another using a button

Re: product(array)

Re: Adding links to records in the child table on the form using a script.

Re: Adding links to records in the child table on the form using a script.

Re: Adding links to records in the child table on the form using a script.

Re: product(array)

Re: Trying to e-mail with record in PDF attached

Re: Change colour of a formula box if it’s a year later

Re: Seems basic math and date function are bugged

Re: Trigger on Update not triggering

Re: Initials

Re: Initials

Re: Initials

Re: Trigger on Update not triggering

Overview