Sean

1762
79
0

Joined: Tue Jul 31 23:45:13 UTC 2018

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Fix this forum so you can post a question even if you have forgotten to log in
I agree with Steven. I can easily imagine how bad the spam posts would be if you didn't need an account that you had to login with.
- Sean
- 4 yrs ago
- Learn and Share
- Reported - view
Re: Remove all white spaces from a string
You can use the replace() function. For example, replace(YourTextField, " ", "")
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Iteration
Hi Antonio, I have found in my own experience that the performance starts to slow down when iterating through a table with 5,000 records and 1 select statement per iteration.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Limited to One form per table?
You might want to try the Tab layout element. The main problem with it is you can't use a field on more than one tab.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Is there an easier way to convert a payment choice into a number?
Yes, it goes in the Formula field and you use it by itself without the if-then-else statements. It should be the only line of code in the formula field and it shouldn't be necessary to assign the…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Is there an easier way to convert a payment choice into a number?
Yes there is... https://ninox.com/en/manual/calculations/reference-of-functions-and-language
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Iteration
Difficult to say without seeing the database. I was able to process 4 times the number of your records in less than a minute.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Iteration
In the Mac app, less than a minute. In the browser version, I don't know if it will allow you to loop through that many records at once, but I would expect at least 20 minutes.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Working with formulas
Field B is in a different table?
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Iteration
As far as I know, you can't modify an array, myCat, the way you are trying to. I would leave out myCat and use this as the first line of the for-loop...…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
With total... join('A)ProjectItemsRef'.("Subproject: " + 'Project Item Name' + "" + "Labour: " + sum('B)TimeUsedRef'.hours) + " hours" + " | " + sum('B)TimeUsedRef'.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?
I'm still learning! First, I'd like to say I don't think the default name for a table reference, the table name itself, is a best practice and leads to confusion.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Formula column in List view question
Agassi, You're welcome. You actually didn't say, "Treatments (Tratamientos) is related to Appointments, and Products (Productos) is related to Treatments.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Formula column in List view question
Agassi, I don't think the join() function is going to work because you are trying to combine two separate arrays. This works, but might need a little tweaking... let tName := Treatment.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: is there a solution how to code the analog of the excel EDATE function in ninox?
@Steven, the modulo operator returns the remainder of a division operation. 13 % 7 = 6 13 % 6 = 1
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: is there a solution how to code the analog of the excel EDATE function in ninox?
@Mconneen, the undocumented mod operator is: %
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Editing the content of text files
Hi Peter, I put the following in a button... let tId := this.Id;let URL := "file:///Users/seansullivan/Library/Containers/de.ninoxdb.ninox-mac.Ninox/Data/Documents/data/HTMLTest/files/F/" + tId +…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Formula column in List view question
Please see if this thread helps...…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: The online user manual
Hi John, I think most users are happy with Ninox. I also think there is frustration regarding the lack of updated documentation and list of improvements/enhancements/bug fixes when a new version is…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Comments in Reccords
Hi Karen, I think OP is referring to the comments that can be added to a record when using the browser version. I imagine the function would be similar to the files() function for attachments.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Best way to extract specific numbered word from text field
Hi Robert, I remembered that the Ninox compiler will automatically cast a number as text if one of the terms is text and the "+" operator is used. So...…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Best way to extract specific numbered word from text field
This gets me to post 1000! function word(arg : number) doextractx(Customer_description, "NAME: (\w+) (\w+) ($ID \d+$)", text("$" + arg))end;word(ArgNum) That user-defined funtion will return first…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Best way to extract specific numbered word from text field
Robert, You're welcome. I felt the same way when I started learning regex. You could always create a user-defined function that takes those 2 arguments .…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Editing the content of text files
FWIW, I was able to copy text from a text file attached to a Ninox record to a Text field using the http() function. Is that what you had in mind?
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Best way to extract specific numbered word from text field
The easiest solution to implement would be something like this... extractx(Customer_description, "NAME: (\w+)", "$1") If you want to understand it, here is a resource I like... https://www.rexegg.…
- Sean
- 4 yrs ago
- Get help
- Reported - view

1 30 31 32 33 34 71

Welcome to the Ninox community

Sean

My Posts

Re: Fix this forum so you can post a question even if you have forgotten to log in

Re: Remove all white spaces from a string

Re: Iteration

Re: Limited to One form per table?

Re: Is there an easier way to convert a payment choice into a number?

Re: Is there an easier way to convert a payment choice into a number?

Re: Iteration

Re: Iteration

Re: Working with formulas

Re: Iteration

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Re: Formula column in List view question

Re: Formula column in List view question

Re: is there a solution how to code the analog of the excel EDATE function in ninox?

Re: is there a solution how to code the analog of the excel EDATE function in ninox?

Re: Editing the content of text files

Re: Formula column in List view question

Re: The online user manual

Re: Comments in Reccords

Re: Best way to extract specific numbered word from text field

Re: Best way to extract specific numbered word from text field

Re: Best way to extract specific numbered word from text field

Re: Editing the content of text files

Re: Best way to extract specific numbered word from text field

Overview