Fred

San Francisco, USA

3616
572
5

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

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
- 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
- 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
- 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
- 1 yr ago
- Get help
- Reported - view
Re: Add elements to a choice field
@francesco.stefanello That is some very nice coding.
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 1 yr ago
- Get help
- Reported - view
Re: Rounded amount
Are you rounding with round() or with Number format?
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Matching Phone Area Codes to Region
@Dave Irving Can you add me to your workspace again?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Retrieve a Previous Record Date
Try something like, (make sure to correct any table/field names): let t := this; let xBase := (Contact.Chronos order by 'Date + Time'); let xCurIndex := index(xBase, t);…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Open a website
@George J. Sova If you feel like your question has been answered, please remember to mark the post answered so others will know to look or not.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Open a website
Welcome to the community. Have you looked at the URL field? You can paste a URL into the field and then click the globe icon to have it open in your default browser.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Double Search
@Rafael Since Format is a reference field, so at the root level you only get record Id. If you want to search by data, i.e. MP3 or CD. Then you need to reference the field name in Format that stores…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Double Search
@Rafael forgot that contains() likes the parts to be same data type. so you can wrap Format in a text() command. myArray := myArray[contains(text(Format),me.Search_2)]
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Double Search
Since Format is a relationship field. Data from that field will be returned in an array. You can use the contains() command to do searches in an array. If Search_2 returns record Id from the Format…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to create space in text
@dessein That is interesting. I tried it in a join() and it worked so I guessed it would work in a simple +. I guess I am wrong.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: how to create space in text
@dessein You can add this to your code: let xsp := urlDecode("%20"); Then you can reference the variable xsp as many times as you need. 'field 1' + xsp + 'field 2' + xsp + xsp + xsp + 'field 3'
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Payments plans and Location Fields, demo
You should email Ninox directly as they don't really respond to the Forum.
- Fred
- 1 yr ago
- Get help
- Reported - view

1 67 68 69 70 71 145

Welcome to the Ninox community

Fred

My Posts

Re: Choice field repeat the value of the previous day

Re: Need Script for calculating workdays between 1st record, 2nd record, so on.

Re: Choice field repeat the value of the previous day

Re: Need Script for calculating workdays between 1st record, 2nd record, so on.

Re: Add elements to a choice field

Re: Do I have to pay monthly?

Re: Add elements to a choice field

Re: clearing the Filter option in a column on closing a view

Re: clearing the Filter option in a column on closing a view

Re: clearing the Filter option in a column on closing a view

Re: Syntax for filtering Dates older than from today

Re: Syntax for filtering Dates older than from today

Re: Rounded amount

Re: Formula for button

Re: CSV Problems.

Re: Matching Phone Area Codes to Region

Re: Retrieve a Previous Record Date

Re: Open a website

Re: Open a website

Re: Double Search

Re: Double Search

Re: Double Search

Re: how to create space in text

Re: how to create space in text

Re: Payments plans and Location Fields, demo

Overview