Julian Kirkness

Kirkness_Associates_Ju

Database Consultant

Joined: Tue Dec 04 15:48:15 UTC 2018

http://www.kirkness.com

I build database solutions in Ninox and other cloud based tools for clients in many business sectors

My Posts

Latest Posts

Re: CONDITIONS FOR MAKING A BUTTON SHOW
Hi David - just put not in front of it: not Leader.'Image Formula'
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: How commercialize a template ?
I've done something similar - but the code is based on a date in the app. The process is: 1. the user goes over existing licence limit (number of records) and is prompted to visit a webpage to…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Learn and share
- Reported - view
Re: CONDITIONS FOR MAKING A BUTTON SHOW
That response was actually from me (Julian) - I was logged in as a test user...
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Sending Bulk Emails in Ninox
Hi Stefano Thankyou for pointing out that it was missing - I found that quite a lot of screenshots were missing from the blog pages on my site - not sure how as the files were still there.…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Learn and share
- Reported - view
Re: sum values for a specific data
Ah - in this case use the number associated with the choice which you can see in admin mode for the combo box
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: sum values for a specific data
Hi It would basically be this: sum((select Product where 'Product Name' = "Mouse Mat").Price) If I've understood correctlly that is! Julian
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Linking tables
Just to add to what Nick has said, you may find my recent blog post (Relating to Relational Databases - Part 2), which examines many to many relationships, useful: http://software.kirknessassociates.…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Android App - Option to establish the default database and default table
I can't help with a default database - but you can set the table an app goes to with a simple openTable in the Trigger after open: openTable("Companies",…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Learn and share
- Reported - view
Re: how can I count the different value of a row(select)
Hi David I have a similar structure - Events and Bookings in my case with a Status field agains the booking where option 3 is 'Confirmed'. Here's a formula that worked for me: let thisEvent := this;…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
How to Create Checklists / Tasks

I've just published a blog post called 'Creating Checklists in Ninox' which you can see here: http://software.kirknessassociates.com/blog_files/e7d4179b07c6bcb203ae50a5b26e828f-42.…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- 6replies
- 2134
- Learn and share
Re: Lesson plan
Hi You've maybe got to have a 'Lesson Chapters' Table allowing you to have a many to many chapters per lesson? Julian
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
I've just published an article comparing Ninox code with JavaScript...

I've just added an article to my blog called "Coding Comparison - Exemplifying 'Low Code'" comparing Ninox code with the equivalent Javascript required to achieve the same objective.…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- 1reply
- 814
- Learn and share
Re: Conditional display in calendar ?
I think what Birger was saying is that you use the Show In Calendar Yes/No field's after update trigger to set the value in another date field to null if the Show In Calendar is no and to the…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Anyone want in Integromat integration

Integromat is an amazing tool for integrating apps and building workflows - but unfortunately there is no prebuilt Ninox (cloud) integration with it. If, like me,…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- 2replies
- 1452
- Learn and share
Re: Permanent Recruitment Solutions
Hi Mike I've sent you a direct email... Julian
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Creating many to many relationship between two tables
I would usually hide junction tables (using the Hiden tickbox in the table definition).
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: How to add field date ?
Hi Quentin For this one off email you don't need to use replace (that is only necessary to replace 'place holders' in the templates). So you would only need something like: sendEmail({ from:…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Creating many to many relationship between two tables
You may also find my blog posts about relationships useful (Relating to Relational Databases parts 1 and 2): software.kirknessassociates.com/blog.html To answer the question about automatically…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: How to add field date ?
I think I see what you mean... You could have a button on, say, a contacts record which would send them an individual email and you could build up the text in the code: sendEmail({from:…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: How to add field date ?
I thought I'd already responded!??! Anyway, I'm not sure what you mean by 'Is it possible to make it with a button' - it may be answered in my blog post 'Sending Bulk Emails in Ninox': http:…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to automatically change pasted text to all lowercase ?
You should bookmark the language reference in the manual: https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language I have it open most of the time!
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Formula to view display an unlinked piece of information
If you are simply wanting to display the image from a specific record in another unconnected table the the following should work in a formula: record(Icons,5).…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to automatically change pasted text to all lowercase ?
Hi Yes - you just use the lower(string) function - for example: 'Text (multiline)' := lower('Email Body') which assigns a lower case version of the 'Email Body' field to the 'Text (multiline)' field
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: How to add field date ?
Hi Quentin I recognise that code!! The reason is that the date /time field needs to be converted to text before it can be used in the replace - you should change the line like this: thisBody :…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: all data deleted from database?
You should have a backup - go to manage backups and restore the latest one before the data was lost
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view

1 2 3