John Halls's Profile | Ninox Community

Badges

Latest Posts

Re: Formula for the button
If you look at your data model, it looks like this There is nothing joining your Investors to your Projects. Because a Project can have more than one Investor,…
- John_Halls
- 3 days ago
- Get help
- Reported - view
Re: Formula for the button
@Fred Glad you asked, I was struggling to get my head round this one...
- John_Halls
- 3 days ago
- Get help
- Reported - view
Re: Count items (all) in a dynamic multi choice field
@Graham Brown Fred is right. Should work Graham
- John_Halls
- 4 days ago
- 1
- Get help
- Reported - view
Re: Count items (all) in a dynamic multi choice field
You could repeat the select in a formula field and count the members of the resulting array. count(select table where field1 = value1) All other options seem to give the number of selected items…
- John_Halls
- 5 days ago
- Get help
- Reported - view
Re: “Trigger after open“. Opening a page in fullscreen
Hi Pascal openFullscreen(nid) does open a page in fullscreen, but doesn't maximise the window you are in. Not sure how you would do that outside of manually doing so. Regards John
- John_Halls
- 6 days ago
- Get help
- Reported - view
Re: Trouble finding a column
There’s an extra end, line 14, that isn’t needed.
- John_Halls
- 10 days ago
- Get help
- Reported - view
Re: Trouble finding a column
Sorry, from your original issue, it should be let key := this; if 'Commande?' then let t := (create 'Lignes Commandes'); let d := Offres.Options.'Fiche Option'.…
- John_Halls
- 12 days ago
- Get help
- Reported - view
Re: Trouble finding a column
Just looking at your code you can clean it up with some simple changes 1. 'Commande?' = true and 'Commande?' are the same thing 2. You don't then need a second if to test for false. 2. t.…
- John_Halls
- 12 days ago
- Get help
- Reported - view
Re: Set a field
I don't think there is a way to have a field always visible in the form, as you scroll down. What I do is make the reference field the left-hand most field in the list,…
- John_Halls
- 2 wk ago
- Get help
- Reported - view
Re: Problem accessing a subtable from a reference record
Hi @iliper LTD A couple of things here with lines 5 & 6. 1. You don't need to state the table name, this will bring up an error. 2. You don't have the fields 'USD' and 'ZMW' in the Employees table.…
- John_Halls
- 4 wk ago
- 1
- Get help
- Reported - view
Re: printing multi record reports?
Hi Dave Ninox can't print lists from a view. If you use a script in a button to loop through the records in the view you can update a reference to the record you will be able to print that as your…
- John_Halls
- 1 mth ago
- Learn and share
- Reported - view
Re: Problem accessing a subtable from a reference record
The field is called Employees1 so your first line needs to be let empRec := record(Employees,number(Employees1)); Regards John
- John_Halls
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Seelect where Calculation from 2 entries
@Alexander Prinz This can be written as let myReg := Registration; let myArray := ((select 'Flt Hrs' where Luftfahrzeuge.Registration = myReg) order by Datum); last(myArray).…
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Search for parent
@UKenGB Use a trigger on update in the Grandparent record to keep the parent record up-to-date and in sync
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Views
@UKenGB That's OK. One thing that might be worth doing is to change (select 'bulb∆slightingmodel∆s')['Model∆s¹' = thisModV and not contains(theCurrentLighting,…
- John_Halls
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Views
Hi @UKenGB It's worth a lot! If this is in a formula field, which you say it is, then the problem lies with using a select command to gather the data. Select commands need a reason to run,…
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Views
@UKenGB said: I have a formula field that gathers records from another table Could you post a copy of the code that is in this formula field. Thanks John
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Views
@UKenGB Does the data that's displayed but not being updated come from a formula field, and does this formula field use a select statement?
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Comparing a formula field value with a string from within another formula field
Hi @Vermaji Try taking the alert statement out as it doesn’t work in a formula field. regards John
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: rotate a formula date field
Hi When you say rotate, do you mean go from MM/YY to YY/MM, eg 10/25 to 25/10, or do you mean rotate the text by 90° clockwise? Regards John
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Sort the appointments in the calendar
I've only looked at dates, not date+time or appointments but with a bit of testing I can see they are sorted by the ID of the table plus the record ID. As such these are sorted alphabetically,…
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Modularity is here, baby!
Vey exited about this @Fred . I've been waiting a long time for modularity, with more than a hint of more features to come.
- John_Halls
- 2 mths ago
- 1
- Learn and share
- Reported - view
Re: Download file and JavaScript calling
@Jacques TUR Thanks Jacques. I'll look into BarTender's REST API.
- John_Halls
- 3 mths ago
- Learn and share
- Reported - view
Re: Download file and JavaScript calling
@Jacques TUR Hi Jacques. I use a label printing program called BarTender used extensively in production environments (@Mel will know about this). I am using your program to store the many hundreds of…
- John_Halls
- 3 mths ago
- Learn and share
- Reported - view
Re: Download file and JavaScript calling
@Jacques TUR This is EXACTLY what I was looking for. Thank you!
- John_Halls
- 3 mths ago
- Learn and share
- Reported - view

1 2 3 4 5 35

Welcome to the Ninox community

John Halls

Re: Formula for the button

Re: Formula for the button

Re: Count items (all) in a dynamic multi choice field

Re: Count items (all) in a dynamic multi choice field

Re: “Trigger after open“. Opening a page in fullscreen

Re: Trouble finding a column

Re: Trouble finding a column

Re: Trouble finding a column

Re: Set a field

Re: Problem accessing a subtable from a reference record

Re: printing multi record reports?

Re: Problem accessing a subtable from a reference record

Re: Seelect where Calculation from 2 entries

Re: Search for parent

Re: Views

Re: Views

Re: Views

Re: Views

Re: Comparing a formula field value with a string from within another formula field

Re: rotate a formula date field

Re: Sort the appointments in the calendar

Re: Modularity is here, baby!

Re: Download file and JavaScript calling

Re: Download file and JavaScript calling

Re: Download file and JavaScript calling

Overview