Skip to main content

Ninox-Documentation

Chris Mullett

Chris_Mullett

28
1
0

Joined: Fri Nov 06 11:42:29 UTC 2020

My Posts

Latest Posts

Re: Complex criteria for Select
@Jacques TUR Thanks. Interesting thread, although most of it over my pay grade.
- Chris_Mullett
- 10 days ago
- Get help
- Reported - view
Re: Complex criteria for Select
@Jacques TUR Thanks Jacques. Useful tip re the "-'' to reverse to sort order. I do indeed want to sort by -Index Number not Id. After posting my code I noticed sort wasn't as required and removed the…
- Chris_Mullett
- 11 days ago
- Get help
- Reported - view
Re: Complex criteria for Select
@Sotirios Zormpas@John Halls@Fred@Jacques TUR Thanks for your contributions chaps. Cracked it! let t := this; let myRecordSet := rsort((select Film) order by 'Index Number'); if t.…
- Chris_Mullett
- 11 days ago
- 1
- Get help
- Reported - view
Re: Complex criteria for Select
Thanks Fred. Yes, there are reference fields and filter is interesting, it is similar to the solution I was seeking. Yet again "this", is there a crib sheet for when to use it?
- Chris_Mullett
- 11 days ago
- Get help
- Reported - view
Re: Complex criteria for Select
@John Halls Thanks, this looks promising. I'd tried building a select string, but couldn't get it to work, I hadn't used eval. Yet again the mysterious "this" which keeps popping up.…
- Chris_Mullett
- 11 days ago
- Get help
- Reported - view
Re: Complex criteria for Select
@Sotirios Zormpas Thanks for this and it would be fine if all criteria were selected. The problem is that will not often be the case.
- Chris_Mullett
- 11 days ago
- Get help
- Reported - view
Complex criteria for Select

Hi, I am working on a project which requires a dynamic choice field to be populated by the results of a select based on one or more of four criteria. The criteria are selected at the top of a…
- Chris_Mullett
- 11 days ago
- 20replies
- 75
- Get help
- Answered
- Answered
Re: Using a table selection in script
@Fred That is exactly what I was looking for and I now understand the differences between the two scenarios. I really do appreciate your help with this. Regards Chris
- Chris_Mullett
- 4 mths ago
- Get help
- Reported - view
Re: Using a table selection in script
@Fred Sorry typo in last post, should be ...Film.Chemistry IS empty ... I am struggling to see the difference between your two scenarios, but I think the later is a clearer description .…
- Chris_Mullett
- 4 mths ago
- Get help
- Reported - view
Re: Using a table selection in script
Here is a link to a copy: https://www.dropbox.com/scl/fi/q9st7plthznmjmb116y7x/Copy_for-Fred.ninox?rlkey=pibbfqz583gf2ej9efii6ev6y&dl=0. It will open the Maintenance Dashboard and I've added couple…
- Chris_Mullett
- 4 mths ago
- Get help
- Reported - view
Re: Using a table selection in script
@Fred Thanks Fred. There are two tables, Chemistry (containing a few details of the chemistry used for development) and Film, which contains info about the films I used,…
- Chris_Mullett
- 4 mths ago
- Get help
- Reported - view
Re: Using a table selection in script
@Fred I've spent some time exploring the use of Dynamic Choice fields and I thin k it is the way to go. I've looked at your db and it almost makes sense to me although it doesn't seem to work…
- Chris_Mullett
- 4 mths ago
- Get help
- Reported - view
Re: Using a table selection in script
@Fred Thanks Fred. This looks very interesting. I'll spend sometime looking at this and seeing how to use the techniques to solve my issue.
- Chris_Mullett
- 4 mths ago
- Get help
- Reported - view
Re: Using a table selection in script
Thanks Fred, should have been more descriptive. Basically I'm trying to bulk update records which I manually select and which are not necessarily selectable by query.…
- Chris_Mullett
- 4 mths ago
- Get help
- Reported - view
Using a table selection in script

Hi, I'd like to be able to scroll through a set of records in a table and update values on each record. I want to select the records using the selection feature on table view, as used for bulk update,…
- Chris_Mullett
- 4 mths ago
- 13replies
- 88
- Get help
- Answered
- Answered
Re: Filter on hidden columns
@Fred Thanks Fred. This together with the info from @John Halls is very useful. enabled me to achieve my objective. Appreciate the help. Regards Chris
- Chris_Mullett
- 2 yrs ago
- Get help
- Reported - view
Re: Filter on hidden columns
@John Halls Thanks John. Sneaky! I love it, job done, appreciate the help. Regards Chris
- Chris_Mullett
- 2 yrs ago
- Get help
- Reported - view
Re: Filter on hidden columns
@Fred Table Camera has ID, Camera_Name (text), Roll/Sheet (Choice - see Screenshot 1) .... Table FilmStock has Film (Text), MediaType(Multiple Choice - see Screenshot 2).........…
- Chris_Mullett
- 2 yrs ago
- Get help
- Reported - view
Re: Filter on hidden columns
@Fred Sorry should have been more specific. I'm hoping to be able to add a combo box to a form based on the view. Currently I get a concatenated string showing all the values in the name and format…
- Chris_Mullett
- 2 yrs ago
- Get help
- Reported - view
Filter on hidden columns

Hi, How do I get a view which is a subset of the main table which does not show the field to which the filter is applied. I have a table which lists photographic films which has a text field for…
- Chris_Mullett
- 2 yrs ago
- 8replies
- 161
- Get help
- Answered
- Answered
Re: Default value for subtable reference field.
Hi Jacques, Not sure if you have done anything with this yet but I have figured a workaround I had tunnel vision on trying to set the default in the trigger,…
- Chris_Mullett
- 3 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
Jacques, if I have: Trigger let MyCameraID := Sessions.Camera.Id;let MyLensID := first(select LensPairings where 'Select Camera' = MyCameraID and Type > 1).…
- Chris_Mullett
- 3 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
Thanks for your patience Jacques. The first assignation is redundant, was there withe an alert to test code, I deleted the alert but forgot the assignation line.…
- Chris_Mullett
- 3 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
It is me being a complete novice with Ninox., it is the name of a field in LensPairings.
- Chris_Mullett
- 3 yrs ago
- Get help
- Reported - view
Re: Default value for subtable reference field.
Jacques, thanks, I feel a dope for that. but adding the : to make: let MyCriteria := 1;Lens := first(select LensPairings where Type > MyCriteria);let MyCameraID := Sessions.Camera.…
- Chris_Mullett
- 3 yrs ago
- Get help
- Reported - view

1 2

Back to top

Ninox-Documentation

Overview

View all topics