Lars

0711

Joined: Wed Mar 09 18:31:43 UTC 2022

My Posts

Latest Posts

Re: Dimensioni campo formula
I would like to help, but I don't speak Italian and Google Translate is no big help. I don't understand what you mean with 1 or 2 dimensions - can you please explain?…
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem
Steven is right: If you want "Documents between From Date to To Date", then you have to use AND. Otherwise you get ALL dates before myTo AND ALL dates after myFrom - which is actually all dates
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: Searching not working as expected (new to Ninox)
If you use the "Choice" type for your status field, you can directly filter by value. Filtering is easier than searching. And you can still search for other keys on top of the filter
- Lars
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Jump to tab from a View
Can you give an example for a view field? Usually, if you show tables in a tab, then you jump to that record if you click on it. If you talk about formula fields in a tab:…
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: Date of value specific changing
Hi IDAO, you could search for all records with a negative value, sort them by date (given you have a date field in the record) and then take the first one.…
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger button and code to open calendar
@claudemuller Well then ... just as an idea: The calendar has a fixed URL. If you customer uses the system already in a browser, you could use the openURL function and feed it with this URL.…
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: database wide variables
Hi Dariel, why don't you calculate your values? I don't know how you store the school year, but let's assume, it's a string like "2021 - 2022". So to get the interesting part,…
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: monthName Format
@Dan James (Ninox Partner) I was sure there was something like this, but didn't find it. Thanks for pointing that out.
- Lars
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Formalae for Summing products selected
It depends ... I'd propose to use a dynamic multiple choice (DMC) field 'Multiple Choice' in one table. Then you store your products in another table 'Products'.…
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger button and code to open calendar
This might be too simple an answer, but the calendar is in the menu at the left. So why program another solution?
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: monthName Format
Hi Simon, what about substring(monthName(yourDate), 0, 3);
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: extractx problem
@Louis Cornacchia Louis, you forgot the whitespace. But the comma is also something you didn't mention before. So here's a solution that covers your example: let mytext := "17 - Brian Fortunato ,…
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: Character Occurrences Count
One more: the whole let a := countLetters(xCarPar, "A"); let b := countLetters(xCarPar, "B"); let c := countLetters(xCarPar, "C"); let d := countLetters(xCarPar, "D"); let e := countLetters(xCarPar,…
- Lars
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Character Occurrences Count
Next proposal - replace let cfparz := switch xLunCog do case 1: text(xConCog) + "XX" case 2: text(xConCog) + "X" case 3: text(xConCog) default: substring(text(xCog), 0, 3) end by rpad(text(xConCog),…
- Lars
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Character Occurrences Count
With what I just learned, you can use item("ABCDEHLMPRST", number(month(DataNascita))-1) to replace switch text(month(DataNascita)) do case "1": "A" case "2": "B" case "3": "C" case "4":…
- Lars
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Character Occurrences Count
@RoSoft_Steven Rooryck Thanks a lot - it isn't mentioned in the manual. That makes it a little bit nicer to extract a character than with substring(text, i, i+1).
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: Character Occurrences Count
@Alain Fontaine Now I'm curious ... I thought that 'item' can only be applied to arrays and JSON. You are also doing this on a string. How is this possible or am I missing something?
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: Character Occurrences Count
@Gianluca Yes, if you define it in the global options, it will be available everywhere in this database. However, I'd recommend Alain Fontaine's solution.…
- Lars
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Character Occurrences Count
And I forgot: if you need this more than once in your script, you can define it as a function: function countLetters(myString : text, myLetter : text) do let found :…
- Lars
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Character Occurrences Count
@Gianluca of course, instead of alert(found) you can use anything you want: found as last line just returns the value and displays it. myfield := found assigns the result to a field of your table…
- Lars
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: extractx problem
I feared so ... here's the trick. Just add a " " to the allowed characters let mytext := "whatever you want - whatever you like"; let textfield1 := extractx(mytext, "^\b[A-Za-z ]*\b");…
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: Character Occurrences Count
Hi Gianluca, with length() you get the length of a string and use it for iteration. With substring() you can get a character from a string. Then you compare and Bob's your uncle: let mystring :…
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: extractx problem
Hi Louis, I'm not sure if your text field is something like "wordA - wordB" or "any text with as many spaces as you like - and another text with 4 or more word separated by the minus sign".…
- Lars
- 3 yrs ago
- Get help
- Reported - view
Re: Set auto completion on Ninox editor
It works - awesome and thank you so much. I think you have to install it in each database you have, but that's worth it. Or am I wrong?
- Lars
- 3 yrs ago
- Learn and share
- Reported - view
Re: Finding the sum of the last entry given specific text in a field
Hi Alex, just summarise all the separate values for one month, i.e. 0.00, 10.14, 40.00, 30.00 ... that will yield the same result and you can easily access these values with a select command on the…
- Lars
- 3 yrs ago
- Get help
- Reported - view

1 2 3

Welcome to the Ninox community

Lars

My Posts

Re: Dimensioni campo formula

Re: Formula Problem

Re: Searching not working as expected (new to Ninox)

Re: Jump to tab from a View

Re: Date of value specific changing

Re: Trigger button and code to open calendar

Re: database wide variables

Re: monthName Format

Re: Formalae for Summing products selected

Re: Trigger button and code to open calendar

Re: monthName Format

Re: extractx problem

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: extractx problem

Re: Character Occurrences Count

Re: extractx problem

Re: Set auto completion on Ninox editor

Re: Finding the sum of the last entry given specific text in a field

Overview