John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Clearing filters on loading a table
@Jacques TUR Thanks Jacques, excellent description of how it does its magic.
- John_Halls
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 8 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
- 8 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
- 8 mths ago
- Get help
- Reported - view
Re: Ninox 3.13
In computing terms this is called indirection and is super useful.
- John_Halls
- 8 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
- 8 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
- 8 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
- 8 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
- 8 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
- 8 mths ago
- Get help
- Reported - view
Re: Countdown Date
@Fred yes, of course. Good spot.
- John_Halls
- 8 mths ago
- Get help
- Reported - view
Re: Button that creates a new record for the next month
You are using this Table1.(Promotion := null); Table1.('fine/punishment' := null); Table1.(Comment := null); and, surely it should be this newRec.(Promotion := null); newRec.…
- John_Halls
- 8 mths ago
- 2
- Get help
- Reported - view
Re: Countdown Date
@Fred I think this method will also give a more accurate result. 2629746000 is the number of milliseconds in a month but this must be a generalisation surely?
- John_Halls
- 8 mths ago
- 1
- Get help
- Reported - view
Re: html undefined error
Hi @Alan Cooke This has caught a few people out You now need to include the html: element, even if you are not using html. Try adding html: null, to your code. Regards John
- John_Halls
- 8 mths ago
- Get help
- Reported - view
Re: How to disable Create Record button in reference
@Mel Charles Did you ever use Foxpro? Great product until it went over to Visual Foxpro and become object orientated (eek!). I reverse engineered Pegasus II (also written in Foxpro) in a week and…
- John_Halls
- 8 mths ago
- Get help
- Reported - view
Re: How to disable Create Record button in reference
I might try to put together a pros & cons list, when I have more time on my hands.
- John_Halls
- 8 mths ago
- 1
- Get help
- Reported - view

1 4 5 6 7 8 33

Welcome to the Ninox community

John Halls

My Posts

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

Re: help please on this script

Re: Button that creates a new record for the next month

Re: Button that creates a new record for the next month

Re: Button that creates a new record for the next month

Re: Button that creates a new record for the next month

Re: Countdown Date

Re: Button that creates a new record for the next month

Re: Countdown Date

Re: html undefined error

Re: How to disable Create Record button in reference

Re: How to disable Create Record button in reference

Overview