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
Plugins
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
3920
posts
632
likes received
5
followers
Badges
Latest Posts
Re: Ver 3.10 - new PAGES Feature
@Sotirios Zormpas I'm transitioning one of my dashboards and it is a lot of work. Maybe once Jacques fixes Ninext's copy/paste to work in Pages then it will be easier.…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Convert total time not in days but only in hours
I guess I answered the question. If you convert your time data into decimals then you can use the column sum function and you will get what you want.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Convert total time not in days but only in hours
ERKENS ChristopheIf that is what I think it is, a table form column function, then I think the answer is No. You can't change how Ninox does sum of columns.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sum Based on Choice
@danlap333 When you get a chance, please mark the post answered.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sum Based on Choice
@danlap333 said: 1) Statement Month is a simple choice field that I choose 2) Table name is "Receipt Details" 2) Table name that I want to get the totals from is "Receipt Details",…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Script problem.
@Rafael How did it work before since it using the same table reference. Just put the correct table name.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sum Based on Choice
just to confirm: 1) Statement Month is a simple choice field or a dynamic choice field. 2) What is the table name of the screenshot? What is the table name that you want to get the totals from?…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Script problem.
If you only want the last record then you don't need a for loop. You can try this modification: do as server let me := this; let i := last(select 'Task templates'); let new := (create Tasks); new.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Copy to clipboard: Multi-line referenced table
@Taylor Hanson said: Below is what I've placed in, but now, it doest seem like anything is working... You are still putting in all the code. Let us make this a bit simpler.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Script problem.
@Rafael said: Is there some way to only copy the last or last one included, not all records. You only want to copy the last record in the Task Template table? Have you tried the last() command?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Copy to clipboard: Multi-line referenced table
@Taylor Hanson The copy estimate button in the Job Status Log table doesn't do anything for me. Is that the right button. I click on it and when I paste nothing happens.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Ver 3.10 - new PAGES Feature
Another warning to users who use the app. Don't edit your pages in the app as it will turn it back into a table in the browser.
Fred
Fred
2 yrs ago
1
Learn and share
Reported - view
Re: Ninext project
@Jacques TUR Sadly paste from another table does not just work in a Page. Nothing happens. If I go to a regular table it pastes fine. Copy within a Page or to another table doesn't work either.…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Ver 3.10 - new PAGES Feature
Since the apps are not updated to 3.10, I was wondering how a Page would show up in an app. Well, in MacOS v3.9.3, a Page shows up as a table. You can add records.…
Fred
Fred
2 yrs ago
1
Learn and share
Reported - view
Re: Copy to clipboard: Multi-line referenced table
@Taylor Hanson said: I'm not sure what I'm getting wrong... below is all of my current code. When I 'click the button' (formula) and paste it, this is what I'm getting:…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: v3.10 Enterprise only?
Well us public cloud users get Pages. But no modularity. :( Now I have to decide if I want to switch all my dashboards over to Pages?
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Copy to clipboard: Multi-line referenced table
@Taylor Hanson said: thank you! Any ideas about how to get things to order like this (with the paragraph returns)? Item Detail #1 ..........$Item Total #1 Item Detail #2 ..........…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: HELP ME RANK PLEASE
@Rafael If they are equal then they should be ranked the same, no? How else would you rank them? You would need a 2nd field to use as a tie breaker.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: HELP ME RANK PLEASE
You can put this in a button in any table: let myCount := 0; let getCars := (select TableA); for loop1 in getCars do let xScore := loop1.Score; let myCount := cnt(getCars[Score > xScore]); loop1.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Copy to clipboard: Multi-line referenced table
There are two ways to do a paragraph return/line break/carriage return. 1) just add a paragraph return: let outputList := ""; let details := 'Project Details'; for r in details do outputList :…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Need Formula on Chart
@Rafael said: Yes I Have a Categories Tables. May I ask why you don't use it as the base for your dynamic field? It would mean you would probably want to change Gastos.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: HELP ME RANK PLEASE
Are you asking for code that you can put in a button that will rank the records for you?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Select records through Dynamic Multiple Choice Field
@Web Name said: The function I apply in the TabSearch.Fx field considers only Gamma and Iota clients and returns 300. It does not consider the Alfa customer because it belongs to multiple categories.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Need Formula on Chart
What kind of field is Categorias in Gastos? The way you created your Categorias dynamic multichoice field is an interesting way of doing it. The one thing I see is dynamic choice fields are based on…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Select records through Dynamic Multiple Choice Field
@Web Name said: In this last table, TabSearch, I would like to insert a formula that takes the largest customer turnover from the TabCustomers.Sales field between TabCustomers records that have the…
Fred
Fred
2 yrs ago
Get help
Reported - view
1
75
76
77
78
79
157
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
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