Fred

San Francisco, USA

3403
539
4

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

My Posts

Latest Posts

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
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
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Use choice fields in a formula field
The code looks ok. What is happening?
- Fred
- 1 yr 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
- 1 yr ago
- Learn and share
- Reported - view
Re: do as... massive speed improvement
@Rafael You can try putting it after the if check = "Yes" line, remember to add an extra end at the bottom. Since you have dialog and alerts you can't wrap the whole thing in a do as server.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Use choice fields in a formula field
Thanks for the table names. Very helpful. Are Kosten and vastgoed related? Are the six choices in the choice field related to the six formula fields? Can you post the code of one of the formula…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: do as... massive speed improvement
I thought the do as Transaction would be a great command, but sometime I get the following error on the web version of Ninox: Nothing that is show stopping, but annoying.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Override result in formula field
I guess another option is if you want to keep using the Fee formula field then you need to add a discount number field so you can add this field into the Fee formula field.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Override result in formula field
You said in your original post: @Davie said: but I want to offer a one-off discount and charge £150 I don't see how your Trigger code on Appointment allows you to do this.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Override result in formula field
@Davie said: I have my 'Appointment' and a field 'Fee' which is a calculation from Appointment taking the number of hours and creating a fee. But I think a Trigger After Update can do the same.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: v3.9 is now live
Love how I just got the v3.9 email from Ninox today.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Override result in formula field
My two cents for stuff like tracking cost per invoice per client I would stick with number fields as much as possible so your history is kept accurate. I use formula fields a lot,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Print filtered by date and assigned employee records from the table
@Alina Morgovsky said: I also have to filter “pick up date” in the view of “Report” , and in the print layout as well. So Report is a view element to the Report Table?…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: How to get passed time in months from two dates?
Cause I can't leave well enough alone. The code can be cleaned up to: let sYear := year(Date1); let eYear := year(Date2); let numYear := if eYear > sYear then eYear - sYear else 0 end; let sMon :…
- Fred
- 1 yr ago
- 2
- Get help
- Reported - view

1 59 60 61 62 63 137

Welcome to the Ninox community

Fred

My Posts

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)

Re: do as... massive speed improvement

Re: Use choice fields in a formula field

Re: do as... massive speed improvement

Re: Override result in formula field

Re: Override result in formula field

Re: Override result in formula field

Re: v3.9 is now live

Re: Override result in formula field

Re: Print filtered by date and assigned employee records from the table

Re: How to get passed time in months from two dates?

Overview