John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Does a button only work once ?
I wrote this code for you, and my understanding was that you had duplicates that you want to cleanse from your table. The button would flag the duplicates in preparation for that.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Code to Generate PO Numbers
Here you go... let a := this;let b := format(today(), "MMDDYYYY");let c := "ABCDEFGHIJKLMNOPQRSTUVWXYZ";let d := "";let e := substr(last(((select Orders where substring(Ref, 0, 8) = b) order by Ref).…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: I can't get a Dynamic Choice to select from a table. It works in other circumstances.
Hi Mark This is what the manual says:- record(tableName, recordId)record(tableName, recordId).fieldNameUse the record function to return the nth record id of a table as a handle.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Automatic record creation
Sorry, hit 'Post' before I meant to. The code will look like this if Table1.Formula > 0 and cnt(Table1.Table2) = 0 then let a := Table1; let b := (create Table2); b.(Table1 := a)end Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Automatic record creation
Hi Giovanni You can place the trigger in Table 3 as this is the table being updated. Use the Trigger on update and place this code in it
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: No duplicate absent…
Fred is right. This is working but, depending on why you are doing this, it won't get you any further forward in finding one original and deleting or flagging the duplicates.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: data export to excel 05-01 needs to stay 05-01 but ecel shows it as 5th Jan!
I have a similar problem. All my product code are three digits, a full stop and then four digits, eg 112.0036 Its such a pain when I export to Excel and re-import as some will truncate, 113.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
I still haven't seen a screenshot where you have an "x" in both 'Trés petite taille' and 'Petite taille'. Only then will you seen an "x" in your formula field 'Petite taille et Tres petite taille'
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
The formula will give its result automatically and has nothing to do with the filter. You can, of course, filter the result if you so wish.
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
I have't put anything in the filter box. Before moving on to that test your code with an "x" in each of the fields and see if your formula gives an "x".…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Is this what you are looking to have?
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
That is correct. It will only have an "x" in it if both Trés petite taille and Petite taille have an x in them and there are no records in your screenshot that have that.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Help with a new connect view with dashboard button....
Hi Michael Your code above can be simplified to let myFrom := From;let myTo := To;let me := this;Invoices.(Dashboard := 0);for i in (select Invoice)['Invoice Date' >= myFrom and 'Invoice Date' <=…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Two search in a base
In your formula field "Trés petite taille et Petite taille" put this code if 'Trés petite taille' = "x" and 'Petite taille' = "x" then "x" end Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Dynamic choice field - showing Id instead of description in print view
No, I realised it can be done inline after I posted. Always the way...
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Dynamic choice field - showing Id instead of description in print view
OK after some trial and error I cane up with this You are correct. In print view it wants to take the record number but you can update the formula in the print view as shown Here my dynamic choice…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Help with a new connect view with dashboard button....
Hi Michael You took this from the example 112_Print view element in dashboard. This example allows the dashboard to be printed (as views can't but relationships can).…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Help with a new connect view with dashboard button....
Hi Michael What is the field name in invoices for the outstanding amount. Is this a number or a yes/no style flag? Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: How to delete role ?
I believe the role is deleted once it has been removed from the last user given it.
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Help with an Excel like formula in Ninox
Hi Can I ask, are Teachers and Specialists different people or can a Specialist be a Teacher and visa versa? Thanks John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: How do I get dynamic Choice field towork?
I have a similar journey to you but mine started with Foxpro to FileMaker to Ninox. I have learned that to get to grips with FileMaker I had to forget about Foxpro and think FileMaker.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: I think we have a new record for spam posts
I was planning on replying to someone over the weekend. I don't think I'll be able to find the post now. Even if I did, this might continue and they wouldn't see my answer.
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Help with an Excel like formula in Ninox
Glad we can help. I'm busy for a few days but will try to reply in more detail over the weekend, if not before. Unfortunately you won't be able to re-create the look of the spreadsheet (the nearest…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Help with an Excel like formula in Ninox
Sorry... Re Example 3. PERIODS in yellow and JOIN in green
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Help with an Excel like formula in Ninox
Hi Moving from Excel to a database can require a bit of thought. Each sheet can look similar but require different treatment in a database. Example 1. A single table This import would require just a…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view

1 25 26 27 28 29 33

Welcome to the Ninox community

John Halls

My Posts

Re: Does a button only work once ?

Re: Code to Generate PO Numbers

Re: I can't get a Dynamic Choice to select from a table. It works in other circumstances.

Re: Automatic record creation

Re: Automatic record creation

Re: No duplicate absent…

Re: data export to excel 05-01 needs to stay 05-01 but ecel shows it as 5th Jan!

Re: Two search in a base

Re: Two search in a base

Re: Two search in a base

Re: Two search in a base

Re: Two search in a base

Re: Help with a new connect view with dashboard button....

Re: Two search in a base

Re: Dynamic choice field - showing Id instead of description in print view

Re: Dynamic choice field - showing Id instead of description in print view

Re: Help with a new connect view with dashboard button....

Re: Help with a new connect view with dashboard button....

Re: How to delete role ?

Re: Help with an Excel like formula in Ninox

Re: How do I get dynamic Choice field towork?

Re: I think we have a new record for spam posts

Re: Help with an Excel like formula in Ninox

Re: Help with an Excel like formula in Ninox

Re: Help with an Excel like formula in Ninox

Overview