Fred

San Francisco, USA

3701
591
5

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

My Posts

Latest Posts

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
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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: v3.9 is now live
Love how I just got the v3.9 email from Ninox today.
- Fred
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: How to get passed time in months from two dates?
Here is one way. Not as clean as Excel but it works: let sYear := year(Date1); let eYear := year(Date2); let numYear := if eYear > sYear then eYear - sYear else 1 end; let sMon := month(Date1);…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Calculating hours from Appointment
May I recommend another way. You can use the ceil() command. It would look something like: let x := number(duration(Appointment) / 3600000); ceil(x) In Ninox, time is kept in milliseconds.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view

1 71 72 73 74 75 149

Welcome to the Ninox community

Fred

My Posts

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?

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

Re: Calculating hours from Appointment

Overview