Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.
@Dave Irving I don't think Ninox can do magic and make up records. :) Are you sure you are showing all records in your table? Can you post a sample of your DB? It would be easier to troubleshoot.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Remove comma from dmc-print layout
can you post your code? or You can look at this post for some ideas.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.
@David Irving If you want to investigate then you can remove the count and put concat in front and it will show you the record Ids and you can then find out what is going on.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.
Since you have a multiple choice field, Ninox will return an array of numbers. One way to look for a particular selection amongst an array is to use the contains() function.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula to Count item per Week
The following code assumes you are in the same table as the reference field 'Issues A': let listofWeeks := sort(unique('Issues A'.Week)); let crtn := urlDecode("%0A"); let display :…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Formula to Count item per Week
How will you be displaying the data? In a view element? In a formula field that shows text? In a formula field that is using another field that has the week number?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Unable to Archive or Duplicate
I tried it on my iPad (v16.4.1(a)) and Ninox (v3.8.12) and was able to save an archive. Also was able to save as an duplicate into iCloud and local with no issues.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of values of a field of a specific date
@Astavakra said: it’s about all the entries of a similar date - fe all for June 21st 2023 - need it mainly to plan things by days … so doesn’t work with today(),…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: convert formula to NINOX LANGUAGE
Ninox does a good job figuring datetime. The only thing you have to be aware of is that it is all done in milliseconds. So you only have to divide any results by 3600000 (number of milliseconds in a…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of values of a field of a specific date
You can try something like: let x := select TableName where datefield = today(); sum(x.blue) Just replace the TableName with the appropriate table name and datefield with the appropriate date field…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of values of a field of a specific date
What is your view formula, what is the name of the field you want to filter with and what value do you want to filter on?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum of values of a field of a specific date
How will you be selecting the date to filter the results by?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: SELECT function
If you are in TableA and want to count the number of related records in TableC through TableB, you can do something like: count(TableB.TableC) If you are in TableA and want a formula to count the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: SELECT function
which table will the count formula be in?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: SELECT function
Which direction does the 1 to many go? TableA has a 1:N to TableB or TableA has a N:1 to TableB? TableB has a 1:N to TableC or vice versa?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Avoid deleting a record
The best way to control user input is to take over the entire process of record creation/deletion with a dashboard. Basically you are creating another table with just one record where user’s enter…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Multiply a number to get a status
@Sébastien Guillet said: Can I reuse this formula to show me the Chinese sign of a client? Interesting question. You can but just going by year is not accurate as the Chinese New Year typically falls…
- Fred
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: Force trigger after update with mass update
@Marisol Echaide said: Cuenta = "A100-2" So "A100-2" is not the record Id. Go to the Cuentas table. Add the Id field to the table view. Find the first instance of a record that has A100-2 in the ID…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Force trigger after update with mass update
@Marisol Echaide said: I tried to replace the first(select()) command with just the record ID and though I didn't get any error on the code, that specific field was not selected. That is interesting.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Force trigger after update with mass update
@Marisol Echaide said: Exactly, that's what I'm trying to recreate with a yes/no switch. Since the action of setting from blank to yes is an update to the record, it serves to activate the trigger.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Incorrectly calculated Week
@Rafael said: The Table 'Control Issues' apparently Look good. Are '1N_Control_Issues' and 'Control Issues' the same table? You need to see why those 6 records in '1N_Control_Issues' are showing up…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Incorrectly calculated Week
@Rafael said: if you see the first image the Date it does not match with the Week. I saw the image, but it looks right to me. You only asked to match Week so since you selected 17 in the dC field…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Incorrectly calculated Week
@Rafael said: On '1N_Control Issues' the weeks are OK and 'Control Issues' the weeks is ok too. What is wrong. I'm not sure what the problem is if you say everything is OK.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Problem with if and else in a loop
Sadly there isn't an exit command. Since you only want to modify Leads records with a Status = 2, you can add that to your select so you can skip the first if/then.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Force trigger after update with mass update
Just to be clear, you want the button to take all newly imported records from Bancos and create a new record in Entrada/Salidas. Are you familiar with the for loop command?
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 81 82 83 84 85 153

Welcome to the Ninox community

Fred

Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.

Re: Remove comma from dmc-print layout

Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.

Re: Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.

Re: Formula to Count item per Week

Re: Formula to Count item per Week

Re: Unable to Archive or Duplicate

Re: Sum of values of a field of a specific date

Re: convert formula to NINOX LANGUAGE

Re: Sum of values of a field of a specific date

Re: Sum of values of a field of a specific date

Re: Sum of values of a field of a specific date

Re: SELECT function

Re: SELECT function

Re: SELECT function

Re: Avoid deleting a record

Re: Multiply a number to get a status

Re: Force trigger after update with mass update

Re: Force trigger after update with mass update

Re: Force trigger after update with mass update

Re: Incorrectly calculated Week

Re: Incorrectly calculated Week

Re: Incorrectly calculated Week

Re: Problem with if and else in a loop

Re: Force trigger after update with mass update

Overview