Fred

San Francisco, USA

3409
539
4

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

My Posts

Latest Posts

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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: SELECT function
which table will the count formula be in?
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Force a update to trigger all records.
@Marisol Echaide We would be happy to help. Please start a new post and be more descriptive of what you want to achieve.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael Generally, you create new tables to track different sets of data. If the only difference between Real 3,4, & 5 is a date then, in my opinion, you would put them in the same table with a field…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 65 66 67 68 69 137

Welcome to the Ninox community

Fred

My Posts

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

Re: Force a update to trigger all records.

Re: Adapt fórmula to new Structure.

Overview