Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3403
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Created On - Duplicate Records
I was able to duplicate it on my MacOS app(v3.9.3). Sadly this is probably a limitation of the app. I notice that it doesn't keep track of the creation date so you if you don't track it to start with…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Created On - Duplicate Records
Which platform are your using (browser, MacOS app, mobile app)? When I did it in my browser it works fines.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
@Dave Irving Ok, now we do a bit of troubleshooting. 1) verify that "y" has the record Ids that match. You can do the following in another field: let x := (select Leads); let y :…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD let t := this; let oldData := last('Daly result' order by Date); let newRec := (create 'Daly result'); newRec.( 'LIST OF PLAYERS' := t; Category := oldData.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
iliper LTDForget for a second the category field, You want to also link the parent record to the new Daily Result record as well. If you look in the Daily Result table you will see the new records…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD said: Fred I saw it, but didn’t understand how to do it ) Parent Record - what should I write there? You show a screenshot of a record that has the 'Daily Result' table in it.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD did you see my recent post about adding the linking to the parent record?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
I forgot to add the part of linking it to the parent record. let t := this; let oldData := last('Daily Result' order by Date); let newRec := (create 'Daily Result'); newRec.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD can you upload a sample DB?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
This is so that you can track changes in client category, without going into the table. Well then you just need to figure out which record you need to pull the data from.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD said: I created a button outside the table to create a new record and then in the table, but it didn’t work. Create the button in the table that has the Category field,…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
For median you can try something like: let mynumber := ((select 'My table') order by Number).Number; let mycnt := cnt(mynumber); let mymedian := if even(mycnt) then (item(mynumber,…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
@iliper LTD You didn't say it was in a trigger on new Record.
You will have to put this in a button to create the new record and copy the data. The Trigger doesn't have a reference point for…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
@Dave Irving said: This, I need the script to be able to sort each individuals chronos records by date...avg the days between 1st ordered record by date and 2nd record by date.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Choice field repeat the value of the previous day
Just add the name of the field and make it equal to the same name field: let t := this; let newRec := (create Table2); newRec.( MultiChoice := t.MultiChoice; Country := t.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
Dave Irving said: For instance, I want the avg (prefer median) of working days between the 1st contact (first chrono record for that client) and the second contact (second chrono record for that…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Add elements to a choice field
@francesco.stefanello That is some very nice coding.
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Do I have to pay monthly?
Did you buy the MacOS app in the App Store? If you only use the MacOS and iOS app and iCloud storage then you don't need to subscribe to the cloud service.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Add elements to a choice field
@francesco.stefanello said: since I want to delete all the records every time, to recreate them, Well a dynamic choice is your only solution. A regular choice field can only be updated manually.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: clearing the Filter option in a column on closing a view
Yes, in Table view the filters stick, but not in view element or reference table which is what Alan was showing.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: clearing the Filter option in a column on closing a view
@Alan Cooke I'm the owner of the DBs and they don't remember filters if I'm NOT in admin mode.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: clearing the Filter option in a column on closing a view
That is interesting. If I'm not in Admin mode, the column filters do NOT get remembered when I click on another table. This happens with reference tables and views.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Syntax for filtering Dates older than from today
@Dave Irving If I remember correctly, 'Last Activity Date' is already in date format so you don't need the date() command anymore. Glad to see you taking the ideas learned in the forums and modifying…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Syntax for filtering Dates older than from today
Ninox is really good with days. The thing you have to watch out for is you have a date/time field so you have to convert it to date only data with the date() command.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Rounded amount
Are you rounding with round() or with Number format?
Fred
Fred
1 yr ago
Get help
Reported - view
1
58
59
60
61
62
137
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
You will have to put this in a button to create the new record and copy the data. The Trigger doesn't have a reference point for…