Skip to main content

Ninox-Documentation

bflack

bflack

49
3
0

Joined: Sat Oct 06 15:04:26 UTC 2018

My Posts

Latest Posts

Table tab background image on iPad ver 3.13.3

The selected background image available in Options doesn't stick (works temporarily), but then drops. Oddly, the selection works on the desktop version, but after that selection is made,…
- bflack
- 1 mth ago
- 18
- Get help
Re: Button script to select all items in defined Dynamic Multiple Choice field
Some good thoughts. So far in a year there's been only one change, but it was a pain. I don't think it's worth creating a UL, but the notion of a making a table with the groups is interesting,…
- bflack
- 6 mths ago
- 1
- Get help
- Reported - view
Re: Button script to select all items in defined Dynamic Multiple Choice field
Hi Fred, Indeed, I use switch/case to select the dMC's, each with their own criteria --that works well. The Article.Collection is a straight choice field --assigning characteristics to each item for…
- bflack
- 6 mths ago
- Get help
- Reported - view
Button script to select all items in defined Dynamic Multiple Choice field

Contents In a jewelry database, I have a series of Dynamic Multiple Choice fields to identify items and add them to orders/invoices. As an example: Choose Items in Article table with Dynamic…
- bflack
- 6 mths ago
- 4replies
- 59
- Get help
Re: Expression to extract text in a string to the right after a dash character
@bflack Nailed it! See below ... let txt := replace(substr(Item, index(Item, "-") + 1), """", ""); txt := replace(txt, "“", ""); txt := replace(txt, "”", ""); txt Many thanks !! Bob
- bflack
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
This is sooo close. Definitely solved the left curly quote, but there are also a few right curly quotes.
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@RoSoft_Steven Yes, that's what I though. Any thoughts on dealing with smart quotes on some labels?
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflack Here's a screen shot of the script applied to Trying or TRYING labels. The top one had straight quotes and came out right. The next two had leading curly quotes and ending straight quotes.…
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
This works great when the labels have straight-quotes, but sometimes there are smart-quotes (curled marks). Is there a way to cover for both to avoid editing hundreds of labels?
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@Fred Well, thanks. Maybe someone else will have insight. I'm beyond stumped.
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflack this screenshot shows more within the formula input field
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@Fred no red box, this screenshot is from the table view, not within the formula.
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@Fred using local/icloud version
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
the quoted name ("AHDH" - which varies) is always at the end of the text @Fred string
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
"Do the multiple words exist outside the quotes?" --didn't respond to your question ... yes there are multiple words before the dash, actually 3 with spaces in between.…
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflack a screen shot in a formula field. Item is the field with the product labels.
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
I get a syntax error message: #ERR: SyntaxError: Invalid regular expression: invalid group specifier name. Sorry, regex code is beyond me, so I need help debugging.
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
I'll give it a shot. Unclear whether or not if including the quotes (what ever version) will change the sorting.
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflack Another thought, the number of characters AFTER the dash seems consistent, so maybe the script could include a range of characters after the dash ...…
- bflack
- 7 mths ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
Unfortunately the text afterward varies, sometime multiple words. But since I'm only using this for sorting alphabetically, maybe using the first four letters would work.
- bflack
- 7 mths ago
- Get help
- Reported - view
Expression to extract text in a string to the right after a dash character

I need to extract text in strings (product labels) after a dash character. An example string: Pavé Nameplate Necklace - "ADHD". Ideally, the result would be ADHD, but "ADHD" works as well,…
- bflack
- 7 mths ago
- 33replies
- 350
- Get help
- Answered
- Answered
Dropdown menu on database icon not working

The dropdown menu on the upper right corner of the database icon at the Ninox home screen (showing rename, and other functions) doesn't work since update 3.11.5 update (Mac desktop version).…
- bflack
- 8 mths ago
- 3replies
- 83
- Get help
Re: Button script to select/link record on child table
Nice touch! I knew there was a more elegant approach. Thanks
- bflack
- 11 mths ago
- Get help
- Reported - view
Re: Button script to select/link record on child table
Many thanks. This evening I came up with my own buttons (perhaps not as elegant), using the choice field 4 subgroup options 'CollectionGroups': Select All Button ----------------- switch…
Attachment
- bflack
- 11 mths ago
- Get help
- Reported - view

1 2

Back to top

Ninox-Documentation

Overview

View all topics