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 for calculate total of recurring expenses
Hi Giuseppe - This is an interesting question. So I was able to create the following table. There are two scenarios, that come to mind, that you have to account for:…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: How to Sort Localisation fields properly ?
Hi Julien - The sorting is normal text sorting. Computers sort text by sorting by the first character of a string, then the second, etc. So with the following text:…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Trying to "hide" records in main table
You ask if you change 'Received by' to 1,2 or 3 will trigger the script. I'm guessing you have tested out each true scenario and a false (when 'Received by' = 4,…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Trying to "hide" records in main table
are you putting the code we already worked on between the if and end?
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Trying to "hide" records in main table
I forgot to answer your first question. "Would I need to put each script in the respective field under trigger after update?" I'm not sure what you mean by "each script".…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Trying to "hide" records in main table
Hi Hardy - Glad the button is working. What Mel suggest is still two steps away, I am breaking down the steps so you can understand what is going on. Plus it is always a good to test scripts like…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Trying to "hide" records in main table
what you wrote should work. i noticed that there is a space after "newReceived.". There shouldn't be any spaces. let curRec := this;let newReceived := (create Received);newReceived.…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Trying to "hide" records in main table
Just wondering, did you create the same field and field names in the Received table? The second post code doesn't work cause you have a semicolon after newReceived thus ending the line.…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Trying to "hide" records in main table
Hi Hardy - A button is a "layout element". If you go to Edit Fields you will see on the right side Add layout element. From there you can add a button. When you double click on the button field you…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Trying to "hide" records in main table
There is no "Move" command so you will have to hard code the copying of data field by field from the Orders table to the Received table. There will also be many steps to get to your desired results…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Query
Do you want this 3rd table to be a "dashboard" that you can use view info from other tables? You can view this video for the basics on how to create a dashboard: https://www.youtube.…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: How to count days
Hi John - Going off the data in your picture, 1 day would be the appropriate result for the days command as there are 3 records with Type = Call and the earliest date is 17/01/2022 and the latest…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Query
Are you talking about creating a third table? or adding a view element to an existing table? If the field Nr is a reference field in User to Contractor,…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: How to count days
That helps a lot. So let us start small. If we want to find all records where field Type = 1 (or "Calls") in the History table then figure out how many days elapsed between the earliest date and the…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: How to set a value for a switch elements
Hi Heidi - Can you be a bit more specific? Since a switch is based on the value in a field and if the field is NOT a formula field you can put something like this in the formula section of a button:…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: How to count days
You will need to use the days functions. days(datefield1, datefield2)
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Script: Test for 'if this is true and that is true, then..."
your logic is correct, to extend the search you just add "and". Can you post the exact code you are using and why it is not working?
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Retrieving a deleted record made by mistake
Only if you made a backup of the DB.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Spam spam spam span spam egg and chips
Hi Mel - I use to send an email everytime there was spam then I got my hand slapped by their Support team for doing that. And the forums are just the same as they are.…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Trouble with two table references - same settings, different results.
Oh, Davie. You have now experienced another pain point for Ninox users, the Manual or lack of one.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Spam spam spam span spam egg and chips
Sadly Ninox has shown that it doesn't really care. Many of us have complained. Many have gotten responses that they are working on it. And years later we have a new generation of users experiencing…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Sort properly - 12 is less than 2. I don't think so!
"but if an application was to look at a string and see Letter, Letter, Number, Number could it not decide to treat two numbers as a single number and sort acordingly?…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Advice wanted for database design (modelling?)
The question of do you need a separate task table will depend on the data being kept. Are you doing the same task to every photo? Could you be adding more tasks in the future?…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Print View Problem - Select record if
Hi Anna - Just a few questions: I could be wrong, it looks like Journey is a field in another related table to Shipping, what is that table name? What is the name of the reference field that links…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Sort properly - 12 is less than 2. I don't think so!
You have text in your formula so I don't see how Ninox can treat it otherwise. Excel does the same thing. I have a formula that puts together a series of numbers that look like normal numbers, i.e.…
Fred
Fred
4 yrs ago
Get help
Reported - view
1
133
134
135
136
137
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
