John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
- 11 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
- 11 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
- 11 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
- 11 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
- 11 mths ago
- Get help
- Reported - view
Re: Countdown Date
@Fred yes, of course. Good spot.
- John_Halls
- 11 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
- 11 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
- 11 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
- 11 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
- 11 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
- 11 mths ago
- 1
- Get help
- Reported - view
Re: How to disable Create Record button in reference
@我是我的我 The basics of FileMaker are slightly harder to learn than a good understanding of Ninox. Start to build something in FileMaker with a basic understanding and it is very easy to get caught up…
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: How to disable Create Record button in reference
@Vermaji Re FileMaker, I'd say beware what you wish for. I have used FileMaker for 20 years and, yes, it has immense power but if yours is anything other than a small project it will require detailed…
- John_Halls
- 11 mths ago
- 1
- Get help
- Reported - view
Re: Calculate the percentage if this result is negative
This formula will return 1 if x is negative, and 0 if x is positive. You can then multiply it by your discount to return the discount or zero abs((sign(x)-1)/2) Regards John
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: Regarding 'history' issues.
Hi I would suggest adding a button with a script that updates the value of your text field to a different value and then puts the original value back in.…
- John_Halls
- 11 mths ago
- 1
- Get help
- Reported - view
Re: About the issue of allowing edits only when conditions are met…”
If you have a professional subscription a whole lot of power comes with the upgrade. The Readable if... and Writeable if... sections are available at a table and a field level. Regards John
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: Create new record with outside button
Hi @iliper LTD Can you use the duplicate() function. Sub-tables are duplicated with the relationship intact. let t := this; let oldData := last('Daily Result' order by Date); let newRec :…
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: Navigation Buttons
@Alan Cooke when does it come out Alan?
- John_Halls
- 11 mths ago
- Learn and share
- Reported - view
Re: The script don't work
If I am understanding this correctly and Categories is the table and Categories_> is the relationship you can just use Categories_>.Rate Either assign this to Rate by Categ or use is as is and don't…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: The script don't work
Also need 'Rate by Categ' = rate to be 'Rate by Categ' := rate
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: The script don't work
Hi @Rafael You need to add a first() function in your select statement to return a record rather than an array let rate := first(select Categories where Category = catg).Rate; Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Time to create more work for myself...
Super impressive Fred. What sport is this?
- John_Halls
- 1 yr ago
- Learn and share
- Reported - view
Re: Database Split
Hi Mel. Thank is a pain, that if you want to re-order the tabs you need to move all the fields as well.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Database Split
Thanks Alan. I didn’t know that!
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
@Fred Hi Fred, so good to see these techniques unfold. I have NEVER used range() before. It's such a powerful function. Unlike the for i from 0 to 10 do statement range() allows for descending…
- John_Halls
- 1 yr ago
- Get help
- Reported - view

1 5 6 7 8 9 33

Welcome to the Ninox community

John Halls

My Posts

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

Re: How to disable Create Record button in reference

Re: How to disable Create Record button in reference

Re: Calculate the percentage if this result is negative

Re: Regarding 'history' issues.

Re: About the issue of allowing edits only when conditions are met…”

Re: Create new record with outside button

Re: Navigation Buttons

Re: The script don't work

Re: The script don't work

Re: The script don't work

Re: Time to create more work for myself...

Re: Database Split

Re: Database Split

Re: Help with code to create non-repeating set of 10 numbers

Overview