Fred's Profile | Ninox Community

Badges

Latest Posts

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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 1 yr ago
- Learn and share
- Reported - view
Interesting HTML functionality

So I have a dashboard with three formula fields that show HTML tables. Here are the Leagues and their respective colors. Now on my dashboard the GCL League looks like this:…
- Fred
- 1 yr ago
- 9replies
- 218
- Learn and share

1 45 46 47 48 49 153

Welcome to the Ninox community

Fred

Re: Duplicate record has stopped working

Re: createXLSX: format column as currency

Re: Range Date between two dates 'Plan' and null the other date 'Real'

Re: View of contacts with large number of rows

Re: createXLSX: format column as currency

Re: Linking Related Fields between two tables

Re: createXLSX: format column as currency

Re: Need help organizing some information

Re: HTML Pivot Table

Re: HTML Pivot Table

Re: Is it possible to merge two records in same db?

Re: Linking Related Fields between two tables

Re: Is it possible to merge two records in same db?

Re: Interesting HTML functionality

Re: Script executed automatically on a date

Re: Interesting HTML functionality

Re: HTML Pivot Table

Re: Interesting HTML functionality

Re: Find event in the same date

Re: HTML Pivot Table

Re: Interesting HTML functionality

Re: This is a beginner but I haven't been able to figure it out.

Re: Find event in the same date

Re: Interesting HTML functionality

Overview