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: 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Is this what you are looking to have?
- John_Halls
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: How to create an invoice for a collection of orders?
Our pleasure Martijn
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: How to create an invoice for a collection of orders?
... and again. All select statements removed now and tested with maore than one Shipment record!
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: How to create an invoice for a collection of orders?
Sorry, I made a mistake. I started writing it to also cosolidate all Shipment records and left a select statement in that wasn't neededTo work per Shipment record it should be Regards John
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: How to create an invoice for a collection of orders?
Hi Martijn Using the same data structure I showed this updated code works (I have run it so I know it works). It creates an invoice per customer in the shipment record and consolidates the order…
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: How to create an invoice for a collection of orders?
If your data model looks like this Then each shipment is related on one customer and to many orders. this code in a button on the shipment will consolodate the order lines into a single invoice…
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: How can I limit the creation of child records depending on a variable from the parent record?
I think the best way to do this is create a View in TABLE_A. Place this underneath the Relationship field In the formula put TABLE_B. In Display field only if:…
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view

1 23 24 25 26 27 31

Back to top

Ninox-Documentation

Overview

View all topics