Fred

San Francisco, USA

3381
533
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths ago
- 9replies
- 171
- Learn and share
Re: HTML Pivot Table
@Sotirios Zormpas , great news! I was testing out on my table of 11,000+ records and I was getting about 5 seconds even with a select. I didn't have any loops,…
- Fred
- 9 mths ago
- Learn and share
- Reported - view
Re: Need help organizing some information
@BuffaloTony Yeah, printing is a whole another beast in Ninox. I would recommend NOT using the default print engine as it is pretty bad. Start looking into dynamic printing.…
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTony Looks like color() only like single choice fields, don't know if it likes dynamic choice. Is there a reason Position is multi choice? It might be better to have a separate record for…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTony Looks like I don't have your most recent version of the DB. What kind of field is Position? In a separate formula field in WorkingPositions can you put:…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTonyThat is because once you put Position in a JSON the data is just the text of the choice. JSON data is classified as [any] data, so it has no other characteristics that Ninox can recognize.…
- Fred
- 9 mths ago
- Get help
- Reported - view

1 28 29 30 31 32 136

Welcome to the Ninox community

Fred

My Posts

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

Re: HTML Pivot Table

Re: Need help organizing some information

Re: Need help organizing some information

Re: Need help organizing some information

Re: Need help organizing some information

Overview