Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Fred
Fred
San Francisco, USA
2590
379
2
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
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 mth 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 mth 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 mth 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 mth 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 mth 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 mth 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 mth 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 mth 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 mth 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 mth 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 mth 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 mth 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 mth 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 mth ago
1
Learn & 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 mth ago
Learn & 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 mth ago
Learn & 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 mth ago
Learn & 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 mth ago
Get help
Reported - view
Re: Dynamic multiple choice filter that works only on Server
@Sam glad it worked. Please mark the post answered when you get a chance.
Fred
Fred
1 mth ago
Learn & Share
Reported - view
Re: Dynamic multiple choice filter that works only on Server
Hi Sam - Once you start working with multiple choice fields (regular or dynamic) then you can't use the equal sign so easily. Luckily now you can use the contains() function to filter on arrays,…
Fred
Fred
1 mth ago
Learn & Share
Reported - view
Re: Optimize this Code is to large
@Rafael 33 and 39. the lines that have the if statements and set the 7 or 14.
Fred
Fred
1 mth ago
Get help
Reported - view
Re: Optimize this Code is to large
@Rafael just change the today variable and the Plan within code to what it should be.
Fred
Fred
1 mth ago
Get help
Reported - view
Re: Submit button with required fields notification.
@Michal Bor What errors are you getting? With such a long piece of code it is very easy to lose track of end statements. Line 125 needs a ";" to close out the if statement from line 36.…
Fred
Fred
1 mth ago
Get help
Reported - view
Re: Optimize this Code is to large
@Rafael said: No works on MAJOR Non Conformities but yes for MINOR Non Conformities. I forgot an end. I also updated the code to use a switch since you have more than 3 Status choices.…
Fred
Fred
1 mth ago
1
Get help
Reported - view
Re: Optimize this Code is to large
@Rafael Are you talking about the Trigger after update for Status? The DB has your old code.
Fred
Fred
1 mth ago
Get help
Reported - view
1
3
4
5
6
7
104
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics