Fred's Profile | Ninox Community

Badges

Latest Posts

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
- 2 yrs ago
- Get help
- Reported - view
Re: Add elements to a choice field
@francesco.stefanello That is some very nice coding.
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 2 yrs ago
- Get help
- Reported - view
Re: Rounded amount
Are you rounding with round() or with Number format?
- 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
- 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
- 2 yrs ago
- Get help
- Reported - view
Re: Matching Phone Area Codes to Region
@Dave Irving Can you add me to your workspace again?
- Fred
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: Extract Record from a Table meeting some criteria
When I copy your code into a test DB I get an error at i.Releases and i.Album. To correct that I had to fix line 3: for i in select Album do I'm guessing you wanted to go through the entire Album…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Use choice fields in a formula field
The code looks ok. What is happening?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
Again, thanks@Jacques TUR for this feature. I wouldn't have been able to clean up my DB of old fields or old relationships without it. I would NEVER have been able to find all the formulas that used…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view

1 75 76 77 78 79 153

Welcome to the Ninox community

Fred

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

Re: Extract Record from a Table meeting some criteria

Re: Use choice fields in a formula field

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Overview