Does Ninox database have a "text message" button that will open up messages application on my Mac ? The same way the phone button opens up the FaceTime/phone call application.

@Marissa ... Well.. Yes.. and No..

YES ...   Create a URL field and prefix a phone number with sms://<phone number> ... When the users clicks the URL icon .. iMessage will pop up configured for that number.

No... I am not sure this will work cross platform.. but I did get it to work on my Mac..   Also.. Pretty sure you cannot "programatically" open iMessage.. it is the user clicking the URL icon .. and the Mac seeing that it is the sms://  protocol that directs it to iMessage.

Give it a try!