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
3862
posts
624
likes received
5
followers
Badges
Latest Posts
Re: View of contacts with large number of rows
@erik I know that Nioxus offers Private cloud hosting services. They say it cost the same to go through them plus Nioxus does the hosting. I don't know anymore than that,…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Duplicate record has stopped working
@Mel Charles Just wondering why you choose duplicate() over create()? If you did create() then you wouldn't have to null out fields you can just set the fields you need.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: createXLSX: format column as currency
If you have time, next Thursday, Nioxus will hold their weekly Zoom seminar and will be going in-depth with createXLSX(). You can sign up with this link.
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Range Date between two dates 'Plan' and null the other date 'Real'
You don't want an 'or'. It should be an 'and'. Plus you are missing a second 'Plan 1' after the or. You use the variable myTo, but you don't define it any where.…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: View of contacts with large number of rows
I found that formulas can slow down display time. Another way is to use a Dashboard to interact with your data. You are probably filtering your table, so why not setup a Dashboard where you are…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: createXLSX: format column as currency
@Puff playing around, I can get the .00 at the end of my numbers and that transfers to the the XLSX sheet: but I can't seem to figure out formulas yet.
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Linking Related Fields between two tables
@Jason LarkinDo you need to do this on a regular basis or just once? If just once then you can use the Bulk Edit and put the same code in. If you do this regularly then maybe you there is a way you…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: createXLSX: format column as currency
You would do it using Ninox format() command when you create your JSON data, instead of in the createXLSX() command. From the looks of it you can't do any number formatting in createXLSX().
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Need help organizing some information
@BuffaloTony said: what you took the time to help me with was basically a KANBAN view. Using the view element is there a way to embed a kanban, the same way you can add a chart?…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: HTML Pivot Table
@Sotirios Zormpas I was wondering if do as server would help, but then when building html I don't know if it will show anything. but it seems like it didn't make much of a difference.
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: HTML Pivot Table
@Sotirios Zormpas my test was done local on my machine. These MBP are fast. 🙂
Fred
Fred
1 yr ago
1
Learn and share
Reported - view
Re: Is it possible to merge two records in same db?
@Robert Fitzmaurice more like the key is used to check to see if an existing record already exist and will either skip or update. so using First Name and Surname may not be the best key as you can…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Linking Related Fields between two tables
I see you have this code in a button in the FAs table: let currentRoom := Room; for survey in select Survey where Room = currentRoom do survey.FAs.(Room := this) end Line 1,…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Is it possible to merge two records in same db?
@Robert Fitzmaurice said: Would like to know what I got wrong too. Was it not using the 'Key' option? That would be my guess. If you don't tell Ninox what field to "key" on then it can't tell what is…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Interesting HTML functionality
@Sean said: All I did was add a Formula field with html(cssStyle2) in it and I can modify font size and color. By the way, this has been the way to implement CSS style changes in Ninox for years.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Script executed automatically on a date
Ninox has no way of running scripts based on date. You can set a script to run when you open the DB. Then that script can then check date/time and run accordingly.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Interesting HTML functionality
@Sean said: I would move the CSS out of the table formula fields and into its own dedicated field so hiding one table or another wouldn't matter. I don't think moving the CSS out of the table formula…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: HTML Pivot Table
@Sotirios Zormpas I didn't do anything. I just loaded the table and it took 9 seconds on my computer in the MacOS app. I don't have a cloud account that can handle that many records. :(
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Interesting HTML functionality
@Sean Thanks for your input. I wasn't trying to get different looks between tables. If you hide the 2nd element then you can't change anything in the first element.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Find event in the same date
@giuseppe Is there a void at the end of the code in the view element? If so, you can either remove the ‘let jobCheck’ part of line 2, or put ‘jobCheck’ at the end.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: HTML Pivot Table
@Sotirios Zormpas said: it takes about 30 seconds to display 184,787 records so far. whaaaat? 184K records? wow it took 9 secs to load on my M2 MBPro.
Fred
Fred
1 yr ago
1
Learn and share
Reported - view
Re: Interesting HTML functionality
@Sean Well I tried using class but it doesn't seem to make a difference. I've attached a sample DB. I'm probably using it wrong. When you open it, if you look at Hiding Elements page you can play…
Attachment
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: This is a beginner but I haven't been able to figure it out.
That is a good start. The best way to learn is to try. Let us step through your code. let me := this; let newR := (create Control); for s in select Documents do newR.…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Find event in the same date
@giuseppe said: Is there any possibility? Most things are possible in Ninox. One that is not possible is for a formula field to modify other fields. Only buttons or triggers can modify other fields.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Interesting HTML functionality
@Sean said: You don't say whether you use classes to differentiate each of your tables or not. Forgot about that, I don't differentiate. That would be another way of doing it.
Fred
Fred
1 yr ago
Learn and share
Reported - view
1
47
48
49
50
51
155
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
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
