Fred

San Francisco, USA

3617
572
5

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

My Posts

Latest Posts

Re: Transfer all info on table to another table (script don't work)
is one of the if statement returning the wrong answer? or is the for loop part not working?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Button. On click - No empty fields and if there’s a dup confirm before adding record via dialog
Welcome to Ninox. You have encountered the first big design point when developing a DB. How to control data entry. May I introduce you the concept of “Dashboards”.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Trying to find a solution (pivot view??)
I can't make a comment on pivot tables, but to get values from your child table is easy. At the parent level, you can create a formula field, we can call it 'Total Roll Premium', with:…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula to Count item per Week
@Rafael add another crtn between display and totalString? I'm not sure what you want to do with "most right", but if you want finer control of the text then you probably have to look into using html.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Remove comma from dmc-print layout
It looks like you are trying to use dynamic fields in a way that it is was not probably designed to do. The dynamic value name looks like it only controls the display of the records within the Ninox…
- 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.
@Dave Irving I've done that myself. Many times. How do you think I knew to ask you about it. Sleep well.
- 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.
@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

1 73 74 75 76 77 145

Welcome to the Ninox community

Fred

My Posts

Re: Transfer all info on table to another table (script don't work)

Re: Button. On click - No empty fields and if there’s a dup confirm before adding record via dialog

Re: Trying to find a solution (pivot view??)

Re: Formula to Count item per Week

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: 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

Overview