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: 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 5 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
- 5 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
- 5 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
- 5 mths ago
- Get help
- Reported - view
Re: Navigation Buttons
@Alan Cooke when does it come out Alan?
- John_Halls
- 5 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
- 5 mths 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
- 5 mths 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
- 5 mths ago
- Get help
- Reported - view
Re: Time to create more work for myself...
Super impressive Fred. What sport is this?
- John_Halls
- 5 mths 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
- 6 mths ago
- Get help
- Reported - view
Re: Database Split
Thanks Alan. I didn’t know that!
- John_Halls
- 6 mths 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
- 6 mths ago
- Get help
- Reported - view
Re: Database Split
My Pleasure Ian It is, in my view, good practice to add a tab layout field in the first position because it gives you far more control going forward. I always include another tab called 'Hidden' as…
- John_Halls
- 6 mths ago
- 1
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
@MZ Ah, that's what I was trying to put together. It would have taken me days to put it so succinctly.
- John_Halls
- 6 mths ago
- 2
- Get help
- Reported - view
Re: Database Split
Hi Ian If I understand it correctly "Database" is a tab which was the first item in the Edit fields... section. This has now been moved down two places.…
- John_Halls
- 6 mths ago
- 1
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
Hi Fred My reply to the previous post gives a non-repeating set of numbers between 0 and 9. It makes an array of 100 numbers but all of them are between 0 and 9.…
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Populate a field with values from a list
This works in the console let letterArray := ["A", "B", "C", "D", "E", "F", "G", "H", "I", "J"]; let numArray := unique(for loop1 from 1 to 100 do [floor(random() * 10)] end); let Text :…
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Populate a field with values from a list
I know it's a bit of a sledgehammer to crack a nut but this gives and array of 0 to 9 randomly sorted let numArray := for loop1 from 1 to 100 do [floor(random() * 10)] end;…
- John_Halls
- 6 mths ago
- 1
- Get help
- Reported - view

1 3 4 5 6 7 31

Back to top

Ninox-Documentation

Overview

View all topics