Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
Mel Charles
Mel_Charles
England. UK
www.118printgroup.co.uk
Follow
Joined
Sat Dec 14 17:00:37 UTC 2019
1373
posts
187
likes received
1
followers
Badges
Latest Posts
Re: Auto-populate pricing from another table?
@Taylor Hanson Have a look at a file of an unfinished DB test I was trying to develop some time ago Look at quote lines. This looks up a product from another table and picks up the pricing.…
Attachment
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Auto-populate Music Library Fields
@an_wessel V5 is the same as V4 but with the table relationship removed. As there is no real link between the tables and it seems unlikely the records in Service Book will be added as child records,…
Attachment
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Ninox tutorials stopped working?
Works fine for me on Safari too :-)
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Ninox tutorials stopped working?
Working fine for me - on Chrome
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Auto-populate Music Library Fields
Fred - thats the joy of music Yes you could conceivably have 2 tunes of the same name in Organ Library. they could be an easy to play or a mores skilled version or in different key signatures - or in…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Ninox tutorials stopped working?
@Randy Try These https://www.youtube.com/@NinoxLearning/videos Plenty of graded series 100, 200 etc videos and excellent learning curve to be had.
Mel Charles
Mel_Charles
2 yrs ago
1
Get help
Reported - view
Re: Auto-populate Music Library Fields
@fred That certainly brings up other music references, but not sure it will search for all. @an_wessel specifically asked for a partial match to "Hymm Title" field not to "Tune" in the service book.…
Attachment
Mel Charles
Mel_Charles
2 yrs ago
1
Get help
Reported - view
Re: Auto-populate Music Library Fields
So Fred somehow we need to take a string of words and use some of that to look at another string of words and pick out certain keywords - but who is to say what keyword is important.…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Auto-populate Music Library Fields
Or maybe have a key field in both tables that only has certain key names ie Saints, Eventide etc. following @an_wessel 's logic If were going to sit at the organ and play Eventide (Yes I do actually…
Mel Charles
Mel_Charles
2 yrs ago
1
Get help
Reported - view
Re: Really dumb .... just want to add 2 number fields together and display total in a 3rd field.
P.s There is nothing dumb about this question. To state a saying "We don't know what we err don't know" Ninox has a learning curve. Once you become familiar with the syntax or idiosyncrasies of how…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Auto-populate Music Library Fields
Fred - I haven't touched the links I have only merged the the two tables as you suggested and deleted the other table which in turn has deleted the table ref in Organ Library.…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Auto-populate Music Library Fields
I have put you the two tables together to show you as Fred's suggestion Have a look. If that works for you then we can tackle or talk you through the second part of your question ie the link and auto…
Attachment
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: double click in a cell puzzle.
Also if you are a bit slow at actually performing the double click - Ninox assumes that you want to slide in the record! before you did the second click
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
@Taylor Hanson I am Lichfield in the UK. We used to have price tables with set price scales per product per customer etc but now as I changed the model as to how we work- we price products on the…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Warning / alert triangle on Table name
The warning highlights when there is definitely an issue. it may not at that time be giving you a functional error - but you may have not have triggered a condition for it to do so yet.…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Conditional Formatting Advice Please
I do something similar to highlight proof days ie if over x days pop a proof flag (and you could also colour them for your qty's
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Conditional Formatting Advice Please
@Alan Cooke what about ">=1"?
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Conditional Formatting Advice Please
Could you not use " > 0" ? or you could add the formula and put count (QUANTITY) >0 this would return a true (yes) then you could count that formula Coloumn not elegant - just thinking off top of my…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
@Taylor NO Buddy - Not so grand as a designer. but do I own a print and branding company. Just for information... My approach to this is ever so slightly different insofar an I don't use a yes/no…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
Taylor Ah ha same industry as me !!! Yep all my quotes use a master header form main quote detail and subform(child) for the quote lines etc. See my thread here on how to deal with the auto Quote or…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Automatic incremental numbers (modifiable)
I would also advise you to put the number field say on another tab on the form and have a formula field on the front form to point to it for reading purposes.…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Automatic incremental numbers (modifiable)
In edit mode of the table form put in the trigger on new record section this script let before := max((select JobDockets).'Job Bag'); 'Job Bag' := before + 1 change jobdockets for the name of your…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: clearing the Filter option in a column on closing a view
Im on web version and db owner. Mine does this table A view 1 (filter say customers to show ARM) data limit applied switch to view 2, same table. customers shows all data.…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Version 3.9x
Process Monitor - I understand this is only available in enterprise private cloud version. not public cloud or apps.
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
Re: Message in Print pdf when..
Just add a formula to the print layout and put something like if FieldA > " " then "Con Il primo iorno di etc etc " FiledA is what ever your field is called use the style the make bold etc When you…
Mel Charles
Mel_Charles
2 yrs ago
Get help
Reported - view
1
14
15
16
17
18
55
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
