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: Get Previous Month
To calculate a previous month you also need to allow for the fact that this might move the date to the December of the previous year. Use something like let t := today(); let d := day(t); let m :…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Prevent old record editing for users with limited access rights
Hi Agassi There are "fields" called 'Modified by', 'Modified on' and 'Created by' (and its alternative _md). To access them they have to included in a formula field.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@David Irving Hope you feel better soon.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: List of years/months/weeks...
@Fred Hi Fred I found the same bug last week. I was projecting stock going forward 200 days and it would work for the first 100 or so and then fail. It was solved by using the date() function,…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Auto enter current date when a field is updated?
If NoteDate is a date field, put this in the Trigger after update of the Notes field. NoteDate := today() Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@David Irving Hi David. Did we answer your question in the end? Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Rafael Thanks Rafael Works like a charm! Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Rafael Shouldn't it be let a := Cod_RQ; (select Renglones)[Subset != null].(Subset := null); Renglones.(Subset := a); openTable("Renglones", "By RQ") Changing Renglones_RQ.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Rafael Your code needs to go in a button.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Alain Fontaine I'd just done the same, may as well include it too!
Attachment
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Rafael It’s in my own system. I can put together an example over the next few days.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Alain Fontaine Marginally faster but far, far better code. Thank you.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
Got the do as server version to work consistently. do as server for a in select Chronos where Subset != null do a.(Subset := null) end; for b in Chronos do b.(Subset := b.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Fred I do as David is asking across my own solution. I can have a few hundred child records per parent and there are times when I want to see more than just six of them at a time.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
Hi David Here's an alternative way. Add a new field to your child, lets call it Subset Add a new child view (let's call it By Client) that matches the existing view but swapping out Client ID for…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@David Irving Did you try it because that's exactly what it will do?
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@Jacques TUR Thank you Jacques. There will be plenty of places for that beauty in my code from now on.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@Sean What does the second parameter in eval() do? I've only ever seen and used "this" Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
Hi David Have a look at this post I put up about Virtual Lists https://forum.ninox.com/t/m1hrzt8 It's not exactly what you describe above, but the end result is essentially the same.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Values of Multiple Choice shown as list in print report
Hi Joren Use Join() in conjunction with chosen() join(chosen('Multiple choice'), " ") Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: while loop stops before reaching end
@Mel Charles @Sean I have a few FileMaker clients and also use it, together with Ninox, for my own business. Love ‘em both.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: I need to build a string for each "checked" multiple choice
Hi Jason Use the chosen() function. https://docs.ninox.com/en/script/functions/chosen Regards John
- John_Halls
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: while loop stops before reaching end
Just tested your db and its working fine for me both for test and main records.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: while loop stops before reaching end
There are a fair number of select statements in the function fields and I would think they are the primary reason for your button failing. Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: syntax problems
@Fred Hi Fred I think Jarno wants the start date of the new record to populate the end date of the previous record. Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view

1 10 11 12 13 14 31

Back to top

Ninox-Documentation

Overview

View all topics