Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
Latest Posts
Re: Export formulas to Excel
Cool! Thanks, Mconneen... I'll keep an eye out.
Laura
Laura
3 yrs ago
Get help
Reported - view
Export formulas to Excel
Is there a way to export the formulas and/or field properties for a given table--not just the field contents?
Laura
Laura
3 yrs ago
2
replies
1,167
Get help
Re: Time-based trigger for calculations
Thanks!
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Select syntax
Elegant, Jörg! Very helpful. Thanks for the tip.
Laura
Laura
4 yrs ago
Get help
Reported - view
Time-based trigger for calculations
Do we have a way to set up a calculation to be performed based on a clock setting? E.g., if TimeX = now() then {populate field Y} Thanks.
Laura
Laura
4 yrs ago
2
replies
1,211
Get help
Re: Select syntax
Agreed!
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Displaying a calculated date field in the calendar
Thanks, rfgeor!
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Select syntax
Since the most recent record would have the highest Id#, you can also do this: max(number(select MyTable where Date < myDate).Id)
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Displaying a calculated date field in the calendar
I haven't been able to figure this out either, and am very interested in any solutions anyone has. Meanwhile, rfgeor, as a quick kludge, what I've done is to create a hidden date field with the…
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Filter Column Records That Have Entries?
Thanks, Leo! I’ll give it a go.
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Filter Column Records That Have Entries?
As a followup, is there a way to use "contains()" in the filter header for a field?
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Median value
Sweet! Thanks, Jörg; that’s a huge help.
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Compute months between to dates
Glad it helped!
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Compute months between to dates
Hi, Raphael, I'm not sure this will work for your purposes, but I've used this before. For date2 > date 1: months ( date2, date1 ) = (year(date2) - year(date1)) * 12 + month(date2) - month(date1)
Laura
Laura
4 yrs ago
Get help
Reported - view
Median value
Greetings, is the median function available for use? I was unable to find it in the manual. Thanks.
Laura
Laura
4 yrs ago
2
replies
1,602
Get help
Re: Button to Create a New Linked Record?
From your description, you're going to also want popupRecord, which will take you to the new note. I'm currently trying to figure out how to use that. Once I get it, I'll drop you a line.
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Button to Create a New Linked Record?
I went back and looked at some of my code and I see what I missed. For a button in table 'Repair' with a subtable linked to it named 'Repair Notes', this code goes in the button: let myID :…
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Button to Create a New Linked Record?
Try using this for the final line instead: nn.(‘default record’ := myID) (note, I’m using ‘default record’ as the name of your parent table.)
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Button to Create a New Linked Record?
Try using this for the final line instead: nn.(‘default record’ := myID) (note, I’m using ‘default record’ as the name of your parent table.)
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Button to Create a New Linked Record?
Oops! Sorry! Correction— nn.('default record'.Id := myID) I'm still learning the nuances of Ninox code, so this may need to be tweaked.
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: Button to Create a New Linked Record?
Try this, SM: let myID := Id; let nn := create Note; nn.(Id := myID)
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: trigger after delete
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: trigger after delete
(Just to be clear, the code I wrote in the example above *does* delete a record and then take another action—the other action being creating a record elsewhere—so it might be worth a look anyway,…
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: trigger after delete
Thanks for clarifying, Fabio.
Laura
Laura
4 yrs ago
Get help
Reported - view
Re: trigger after delete
Hi, Fabio, there are probably more elegant ways to do it than this, but here's how I might move a record to a different table. See Candidates. https://www.dropbox.…
Laura
Laura
4 yrs ago
Get help
Reported - view
1
2
Next
Laura
Laura
33
0
0
Joined: 22 Apr 2017
Follow
Home
Learn & Share
Get help
Webinars
View all topics
Tags