Fred

San Francisco, USA

3381
533
4

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

My Posts

Latest Posts

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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths ago
- Learn and 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
- 10 mths ago
- Learn and 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths 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
- 10 mths ago
- Get help
- Reported - view
Re: Optimize this Code is to large
@Rafael can you upload a sample DB?
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Optimize this Code is to large
@Rafael Does today and 'Plan within' get set properly when Status =2?
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Optimize this Code is to large
You can by putting the if statements in the variables instead of at the top. Something like: let t := this; if Status = 1 then s1 code else let reply := if Status = 2 then dialog(" M A J O R - Non…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Help with Button that inputs Date into parent record
@Dave Irving Look into the dialog() function. You will need to take out the do as server as alerts and dialogs will not show to the end user if they are run on the server.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Submit button with required fields notification.
@Michal Bor remember to mark the post answered if you are satisfied.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Page Break
@john cesta The forum is not the official support channel. You need to email Ninox support directly. support@ninox.com
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Pages - uncontrolled restoring of previous versions by Ninox
That is very troubling. I haven't really used Pages much yet, so I haven't seen this. You can email support and see if they can see if a restore had been initiated.
- Fred
- 10 mths ago
- Learn and share
- Reported - view
Re: Help with Button that inputs Date into parent record
Your third line says to get all records in Leads (select Leads) and change the 'Active Date' of all records that was selected to equal the xDate. You said Chronos is a subtable of Leads,…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: duplicate table problem
I would recommend you email Ninox support for this issue.
- Fred
- 10 mths ago
- Get help
- Reported - view

1 35 36 37 38 39 136

Welcome to the Ninox community

Fred

My Posts

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

Re: Confirm whether all multi-choice in the subtable are selected

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

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

Re: Dynamic multiple choice filter that works only on Server

Re: Dynamic multiple choice filter that works only on Server

Re: Dynamic multiple choice filter that works only on Server

Re: Dynamic multiple choice filter that works only on Server

Re: Confirm whether all multi-choice in the subtable are selected

Re: Dynamic multiple choice filter that works only on Server

Re: Dynamic multiple choice filter that works only on Server

Re: Optimize this Code is to large

Re: Optimize this Code is to large

Re: Submit button with required fields notification.

Re: Optimize this Code is to large

Re: Optimize this Code is to large

Re: Optimize this Code is to large

Re: Optimize this Code is to large

Re: Optimize this Code is to large

Re: Help with Button that inputs Date into parent record

Re: Submit button with required fields notification.

Re: Page Break

Re: Pages - uncontrolled restoring of previous versions by Ninox

Re: Help with Button that inputs Date into parent record

Re: duplicate table problem

Overview