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: 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 mths ago
- Get help
- Reported - view
Re: Ninox 3.13
In computing terms this is called indirection and is super useful.
- John_Halls
- 4 mths ago
- 1
- Get help
- Reported - view
Re: help please on this script
Hi Alan Not sure I can solve the issue for you but I would start by tidying up the code so the the sendEmail() command is easy to understand let CR := " "; let myPdf := printAndSaveRecord(this,…
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: Button that creates a new record for the next month
My full code, above probably won't work as I mean it to. The whole code can simplified to let oldData := last('Monthly Report' order by 'BEG DATE'); let newRec := duplicate(oldData); newRec.…
- John_Halls
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Button that creates a new record for the next month
@Fred Did you know this will work, even for December? date(year(oldData.'BEG DATE'), month(oldData.'BEG DATE') + 1, 1) Date() will roll up the year by 1 and set the month to 1 automatically.…
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: Button that creates a new record for the next month
@iliper LTD newRec.('END DATE' := date(year('BEG DATE'), month('BEG DATE')+1, 0)) This needs to be after you assign 'BEG DATE', so the whole thing becomes, after tidying up.…
- John_Halls
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Button that creates a new record for the next month
@iliper LTD This will give you the last day of the same month date(year('End date'), month('End date')+1, 0)
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: Countdown Date
@Fred yes, of course. Good spot.
- John_Halls
- 4 mths ago
- Get help
- Reported - view

1 2 3 4 5 31

Back to top

Ninox-Documentation

Overview

View all topics