Skip to main content
Forum
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
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3701
591
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs ago
Get help
Reported - view
Re: Add elements to a choice field
@francesco.stefanello That is some very nice coding.
Fred
Fred
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs 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
2 yrs ago
Get help
Reported - view
Re: Rounded amount
Are you rounding with round() or with Number format?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Formula for button
if you want just the customer name because you are using a simple text field (called CustomerName): replace with appropriate field names 'CustomerName' := xCurrRec.Customer.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: CSV Problems.
Did you tell Ninox which field is the key to use to figure out if records are new or not? Here is a test table: Here is my csv: Now at import settings, I select "Only new records".…
Fred
Fred
2 yrs ago
Get help
Reported - view
1
70
71
72
73
74
149
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
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
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
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…