Skip to main content

Ninox-Documentation

bflack

bflack

48
3
0

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

My Posts

Latest Posts

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
- 2 days 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
- 2 days 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
- 2 days ago
- 4replies
- 27
- 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- Get help
- Reported - view
Re: Expression to extract text in a string to the right after a dash character
- bflack
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- 33replies
- 63
- 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
- 2 mths ago
- 3replies
- 49
- Get help
Re: Button script to select/link record on child table
Nice touch! I knew there was a more elegant approach. Thanks
- bflack
- 4 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
- 4 mths ago
- Get help
- Reported - view
Re: Button script to select/link record on child table
Thanks to you, there has been much success. I've broken the list into 4 categories to make Product Selections, and added the buttons modeled from your example.…
Attachment
- bflack
- 4 mths ago
- Get help
- Reported - view

1 2

Back to top

Ninox-Documentation

Overview

View all topics