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: Relating to Relational Databases - Part 2
Hi Karen Thanks for that - I am notoriously bad at spotting my own typos! (now fixed) And thank you for the kind comments about the articles. There has been a lot of chat in Ninox's webinars about…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Learn and share
- Reported - view
Relating to Relational Databases - Part 2

I've now completed part two of the Relating to Relational Databases articles which deals mainly with Many to Many relationships and includes a link with which you can download the sample database.…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- 3replies
- 1616
- Learn and share
Re: send e-mail to multiple users
I would echo Sean's remarks about using test databases to try things out. I'm not entirely certain about the idea of learning another programming language though because Ninox is so much quicker and…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: send e-mail to multiple users
No, you can only add one person at a time - you are actually creating a new record ech time you add a person to a mailing list (in the Contact Email Lists table).…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: send e-mail to multiple users
Ah - the send button hides itself if the mail out has been sent - delete the send date or create a new one and you’ll see it. Maybe I should add a mention of this in the blog post!…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Relating to Relational Databases - Part 1

We have seen a lot of disussion in the webinars recently about the underlying principles of relational databases so I decided to write a series of blog posts about it - trying to illiminate as much…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- 1reply
- 1606
- Learn and share
Sending Bulk Emails in Ninox

Following up from an earlier question in the forum, I have written a blog post about sending bulk emails from Ninox - allowing end users to create email templates and send them to people subscribing…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- 3replies
- 1942
- Learn and share
Re: send e-mail to multiple users
I've written a blog post about called Sending Bulk Emails in Ninox which you can see here: http://software.kirknessassociates.com/blog_files/458b2ac56fab5fd7375f64b354486f37-38.…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: send e-mail to multiple users
Glad it's now working! Yes, what you've set up is a very simple case for sending a specific email to a list of people and then clearing them from the list.…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: send e-mail to multiple users
Just had a thought - I think you should put the code in a button rather than the email field.
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: send e-mail to multiple users
Ah - are you using the App? sendEmail only works with the Cloud version so if you are on the app this won't work.
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: send e-mail to multiple users
Hi - do you have a field called Name inMagnWallContactList - if not that could be a place to start
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: send e-mail to multiple users
Sorry, screen shot hard to see so: "-----------------------------------------------------------------------------------";"This code selects contacts where a Yes/No field (Send Email) is set to yes";…
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: send e-mail to multiple users
Here's what you might end up with to loop through a Contacts table:
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Dialog box from Update trigger
I'm already doing this - I assume the reason this isn't possible is that the update triggers are processing on the server? Would be nice to have though!!
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to trigger code on a timer?
Good news indeed - much needed!
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: If/Then Time Statements
Try something like this: if Target - now() <= 0 then Timeliness := 3else if Target - now() < 900000 then Timeliness := 2 else Timeliness := 1 endend
- Database Consultant
- Kirkness_Associates_Ju
- 5 yrs ago
- Get help
- Reported - view
Re: Dialog box from Update trigger
I am looking to do the same - is it planned to allow alerts or dialogs from triggers? This is a very important part of any validation (letting the user know).…
- Database Consultant
- Kirkness_Associates_Ju
- 6 yrs ago
- Get help
- Reported - view
Is it possible to trigger code on a timer?

For many use-cases it would be useful to be able to trigger code based on a timed event (i.e. 12pm every day) - or triggered by a date field (i.e. date/time = now). Is this in the roadmap?
- Database Consultant
- Kirkness_Associates_Ju
- updated 2 yrs ago
- 10replies
- 2343
- Get help
Is it possible to create a User in code?

It would be very useful to me to be able to create a user in code - the use case is for an HR app - once the new employee is confirmed as having started,…
- Database Consultant
- Kirkness_Associates_Ju
- 6 yrs ago
- 1reply
- 1156
- Learn and share

1 2 3