Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Plugin apps
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3831
posts
614
likes received
5
followers
Badges
Latest Posts
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
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
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
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
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
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
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
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
Fred
2 yrs ago
Get help
Reported - view
Re: SELECT function
which table will the count formula be in?
Fred
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
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
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
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
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
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
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
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
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
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
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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs ago
Get help
Reported - view
Re: Adapt fórmula to new Structure.
@Rafael said: One Question. Wouldn't it be easier to create separate tables for each of the Real 3, 4, and 5 ? separate tables? or separate records? generally when you find yourself creating multiple…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Adapt fórmula to new Structure.
@Rafael Your code doesn’t copy those fields over. You need to add them to the newRec part.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Adapt fórmula to new Structure.
You have to follow your links to get the correct data now that you have changed your loop2 starting point. if count(loop2.'1N_Control Issues'[Date_ref = fDate]) < 1 then let newRec :…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
1
82
83
84
85
86
154
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugin apps
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
