Fred

San Francisco, USA

3381
533
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: How to count number of lines and contents
1st - I would like to be able to have a formula to count the total number of doors surveyed You can try something like: count(select tablename) 2nd - I would like to have a formula to count the…
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: show only relevant table columns based on two criteria
Test upload of a file.
Attachment
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: A way to find out where a specific field is referenced anywhere in your tables?
Thanks to@Jacques you can. It is called the Ninext project. DM Jacques for instructions to install. It was indispensable while I reorganized my DB.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: show only relevant table columns based on two criteria
@Richard v. L. I don't see the file.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: This code works erratically sometimes it works and other times it doesn't
@Rafael said: A small video to see the problem. I don't see a problem. The first time you click the button your are on a record with Cod hr = 600 with a final date of 12 Dec 2024.…
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: This code works erratically sometimes it works and other times it doesn't
@Rafael I don't seem to have that issue. I'm using Public cloud.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: This code works erratically sometimes it works and other times it doesn't
Can you be more descriptive by what you mean "erratically"? Looking at the code it looks like it is doing what you are asking with the data provided.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Formula returning specific values depending on multiple choice selection
@Giovanni Zagarella Have you looked at Alain's code? They are do the same thing but in fewer lines.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Formula returning specific values depending on multiple choice selection
@Giovanni Zagarella said: I have the feeling this is not doable via the switch function though - unless I identified every possible scenario through a line of code,…
- Fred
- 10 mths ago
- Get help
- Reported - view
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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths ago
- Get help
- Reported - view

1 34 35 36 37 38 136

Welcome to the Ninox community

Fred

My Posts

Re: How to count number of lines and contents

Re: show only relevant table columns based on two criteria

Re: A way to find out where a specific field is referenced anywhere in your tables?

Re: show only relevant table columns based on two criteria

Re: This code works erratically sometimes it works and other times it doesn't

Re: This code works erratically sometimes it works and other times it doesn't

Re: This code works erratically sometimes it works and other times it doesn't

Re: Formula returning specific values depending on multiple choice selection

Re: Formula returning specific values depending on multiple choice selection

Re: Automatically link record from one table to open record in another table using a button

Re: Automatically link record from one table to open record in another table using a button

Re: Formula returning specific values depending on multiple choice selection

Re: Expression to extract text in a string to the right after a dash character

Re: Dynamic multiple choice filter that works only on Server

Re: Dashboard Help to Compare This Years Data to Last years Data to same date.

Re: Expression to extract text in a string to the right after a dash character

Re: Dashboard Help to Compare This Years Data to Last years Data to same date.

Re: Expression to extract text in a string to the right after a dash character

Re: Expression to extract text in a string to the right after a dash character

Re: Expression to extract text in a string to the right after a dash character

Re: Expression to extract text in a string to the right after a dash character

Re: Expression to extract text in a string to the right after a dash character

Re: Expression to extract text in a string to the right after a dash character

Re: Expression to extract text in a string to the right after a dash character

Re: Dashboard Help to Compare This Years Data to Last years Data to same date.

Overview