John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Please check this email script
Hi @Alan Cooke Sending the same email from another Ninox member worked. The email came into my inbox!
- John_Halls
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Please check this email script
Your variable CR should look like this let CR := " "; Regards John
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Please check this email script
Hi @Alan Cooke Have you checked your spam folder. On testing sending to myself mine are going into spam yet those sent to another email address of mine were received OK.
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Complex criteria for Select
@Chris Mullett We store the current record, this, to a variable because the current record is not available to reference within a select statement, but variables are.
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Complex criteria for Select
As you have some "Show All" options you may need to build your where clause as a text string and evaluate it, such as let x := text(Filter by Status); let y := text(Filter by Camera); let z :…
- John_Halls
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Stopped working for me
Hi @Rafael There a few things here Why do you open the record, and then assign new values to it? I would do it the other way round Why do you open the record twice? Why do you have sleep(1000)?…
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Record reference numbers
Hi Gary I would also prefix this with a letter or two, so my stock records might be ST001, ST002. I do this so that every record in my database has a unique reference number,…
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Query regarding View Element
Hi @Vermaji Your payments need to be in the same table as your invoices and credit notes, then have an allocations table to allocate payments and credit notes to invoices.…
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Ninox forgetting entries
Thanks for your reply. It’s not binding. Can you show how the Work Job is connected to Client Detail Brief. How are the Job Charges calculated? Thanks John
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Ninox forgetting entries
@RoSoft_Steven That crossed my mind too. Seems the obvious one to look at.
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Ninox forgetting entries
Hi Nick. It would be unusual if Ninox weren’t saving data correctly. The forum would be swamped with queries on the subject. Can you post a sample of your system? Or a screenshot? thanks John
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Clearing filters on loading a table
@Jacques TUR Thanks Jacques, excellent description of how it does its magic.
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: Query regarding the sale price per item in Sale Order
@Mel Charles I REALLY like this Mel. The fields are always in the same place on screen. Super effective.
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: Clearing filters on loading a table
@Jacques TUR One day, when you have a bit of time, could you explain this code to me. Thanks John
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: How to maintain rates in old transactions
@Vermaji Yes, that sounds correct although the link links the whole record so you can see any of the fields if you want to.
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: How to maintain rates in old transactions
@Vermaji yes, but only once. When you have a Menu item linked to a OrderItem you would need to remove the link and re-assign the Menu item for it to revert, which would be unlikely or deliberate.
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: How to maintain rates in old transactions
Hi @Vermaji Keep a reference between OrderItems and Menu so that you can keep track of sales of each item historically but create a price field in OrderItems and in the Trigger after update section…
- John_Halls
- 11 mths ago
- 1
- Get help
- Reported - view
Re: Filter records help please
@Fred You are right. where only works with select statements. Square brackets work with both but can be slower with a select statement.
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: Hi, new to Ninox, trying to count number of Mondays, Tuesdays, etc each month
Here's a function to return the number of a particular day of the week (where Monday is 0 and Sunday is 6, for the month of a given date function countDays(dayOfTheWeek : number,dateToCheck :…
- John_Halls
- 11 mths ago
- 2
- Get help
- Reported - view
Re: Hi, new to Ninox, trying to count number of Mondays, Tuesdays, etc each month
I would tackle this by finding out how many days there are in the month (variable c) and what day of the week is the first of the month (variable d). let a := today(); let b := date(year(a),…
- John_Halls
- 11 mths ago
- 1
- Get help
- Reported - view
Re: Print and Delete buttons are not active
@Vermaji I wouldn't be looking to delete records immediately. It throws up problems in a relational database if child records are not correctly set up (composition on).…
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: SendEmail function not working
@Jack Harper Can you send over the code for one of them. Thanks John
- John_Halls
- 11 mths ago
- 1
- Get help
- Reported - view
Re: help please on this script
@Andrew Dickey Hi Andrew. I assumed DESCRIPTION OF TASK was a field name.
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: help please on this script
Hmmm, not sure why that would be. Can you post the full snippet of code.
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: Ninox 3.13
In computing terms this is called indirection and is super useful.
- John_Halls
- 11 mths ago
- 1
- Get help
- Reported - view

1 4 5 6 7 8 33

Welcome to the Ninox community

John Halls

My Posts

Re: Please check this email script

Re: Please check this email script

Re: Please check this email script

Re: Complex criteria for Select

Re: Complex criteria for Select

Re: Stopped working for me

Re: Record reference numbers

Re: Query regarding View Element

Re: Ninox forgetting entries

Re: Ninox forgetting entries

Re: Ninox forgetting entries

Re: Clearing filters on loading a table

Re: Query regarding the sale price per item in Sale Order

Re: Clearing filters on loading a table

Re: How to maintain rates in old transactions

Re: How to maintain rates in old transactions

Re: How to maintain rates in old transactions

Re: Filter records help please

Re: Hi, new to Ninox, trying to count number of Mondays, Tuesdays, etc each month

Re: Hi, new to Ninox, trying to count number of Mondays, Tuesdays, etc each month

Re: Print and Delete buttons are not active

Re: SendEmail function not working

Re: help please on this script

Re: help please on this script

Re: Ninox 3.13

Overview