Fred

San Francisco, USA

3603
566
5

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

My Posts

Latest Posts

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
- 199
- 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Since Latest Upgrade I Can't Do Anything!
For your MacOS app you can do: Terminal command please try the following to fix the problem: open the Terminal app You can find it via Spotlight search,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: This is a beginner but I haven't been able to figure it out.
Take a look at this post. Give it a try and let us know if you have any further questions.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTony said: is it not possible to do something like: let datacolor := color(DayPosition) I didn't even know color() was a command. Thanks for showing me it. That is a great use of the command.…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 37 38 39 40 41 145

Welcome to the Ninox community

Fred

My Posts

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

Re: Since Latest Upgrade I Can't Do Anything!

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

Re: Need help organizing some information

Overview