Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3747
594
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Automatically link record from one table to open record in another table using a button
So there is a Non Conformity table in Audits Plan? Is there only ever going to be 1 Non Conformity record related the Audits Plan record? If so then you can do something as simple as this in a button:…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Automatically link record from one table to open record in another table using a button
The reference field 'Audit_Code_>' in Non Conformity is a reference field to which table? How do you know which record in Non Conformity you want to open since multiple records can be linked to the…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Formula returning specific values depending on multiple choice selection
wow, 40 choices! Anyways, you can use the switch command, but you have to follow this unwritten twist. Switches go down the list of cases, so you have to remember to put the cases that have the…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Expression to extract text in a string to the right after a dash character
@RoSoft_Steven Weird, I swear when I searched the docs for replace nothing showed up. Now it does.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic multiple choice filter that works only on Server
@Sam That is weird. I looked at one of my posts and I, too, have no option to mark the post answered. I've seen other post get marked so I don't know what is up. Maybe time to send Ninox and email.
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Dashboard Help to Compare This Years Data to Last years Data to same date.
@Dave Irving Looks good. Only 1 select statement.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Expression to extract text in a string to the right after a dash character
@RoSoft_Steven It is funny that the Ninox docs don't even show replace() anymore. I wonder if they will eventually get rid of it.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dashboard Help to Compare This Years Data to Last years Data to same date.
@Dave Irving said: Lets take this year. I want to see the data insights from 01/01/20234 to today() and then show the percentage increase/decrease (as I did with monthly and weekly insights from up…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflack can you post a sample DB?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflackweird, I don't get that. Not sure where to start. What version of the app are you using? I'm on 3.11.5 You can try adding: extractx(fieldName, "(?<=- )(.*)", "", "$1")
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflack where is the error message? I don't see a red box around the 1.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflack is the DB in the cloud or local/iCloud?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflack what is your code?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Expression to extract text in a string to the right after a dash character
@bflack said: Unfortunately the text afterward varies, sometime multiple words. Do the multiple words exist outside the quotes? Here is something that will work easily in extractx() but will give you…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Expression to extract text in a string to the right after a dash character
Here is a quick and dirty regex code that searches for both double quotes and curly double quotes, but I don't know how to put double quotes into extractx() since Ninox thinks they are Ninox code.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dashboard Help to Compare This Years Data to Last years Data to same date.
@Dave Irving If you want just 2024 records then you can just filter by: yearfield = 2024 If you want 2023 to present then you can do yearfield >= 2023
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Expression to extract text in a string to the right after a dash character
Is the text after the dash always four letters? Or Is there another pattern after the dash?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Confirm whether all multi-choice in the subtable are selected
Here is something that will show you which choice have not been selected. let allChoices := (select TableA).number(Id); for loop1 in allChoices do let choiceCheck :…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Dashboard Help to Compare This Years Data to Last years Data to same date.
@Dave Irving oops, forgot that Variable1 is a count an not an array.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dashboard Help to Compare This Years Data to Last years Data to same date.
When dealing with dates, I find it handy to create some formula fields that you can put in another tab in Leads. I would create fields that do: at least: year() month() quarter() you can add:…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic multiple choice filter that works only on Server
In the end only you know what is best for your DB. My comments are just food for thought.
Fred
Fred
1 yr ago
1
Learn and share
Reported - view
Re: Dynamic multiple choice filter that works only on Server
@SamIt doesn't deal with the dynamic fields. The Customer Location is based on the relationship of the customer record to the location table. If a customer changes their location and you remove the…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Dynamic multiple choice filter that works only on Server
@Sam said: is it then possible to deselect one of the two choices that are populated by the trigger? Yes, you can deselect a choice. The trigger could look something like: let selectedChoices :…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Dynamic multiple choice filter that works only on Server
@Sam said: Since, there is only one location, it would be nice to have it auto populate the Location(s). That way if there are 2 or rarely 3, a choice could then be made.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Confirm whether all multi-choice in the subtable are selected
You want a way to see that all choices in a choice field have been selected at least once in a record in the subtable? Just to confirm: Is the choice field a multiple choice or single choice field?…
Fred
Fred
1 yr ago
Get help
Reported - view
1
49
50
51
52
53
150
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
View all topics
