How to enable Javascript

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
- 2replies
- 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
- 2replies
- 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
- 2replies
- 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