Fred

San Francisco, USA

3747
594
5

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

My Posts

Latest Posts

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
- 209
- 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
Re: Need help organizing some information
Messing around a bit more I got this: with this code: let getLaborData := (Labor order by Date); let getUniqueDates := unique(getLaborData.Date); let data := for loop1 in getUniqueDates do { date:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTony said: "Day 1" "Day 2" etc (ultimately I would like there to be 8 days total, as, historically this has been all i would need to schedule. Just a reminder that duplicating field names…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need help organizing some information
Here is a first go at the code: Attached is the modified DB. I created a new table called Labor as I needed dates and people linked. I couldn't figure out a way to programmatically create columns in…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTony can you upload a sample DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need help organizing some information
@BuffaloTony There are ways. If you want to see something like this it would probably take some html/CSS coding. Are you using the app or the public cloud?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need help organizing some information
That looks great. You have done a great job. @BuffaloTony said: I have a relationship table setup in each job that shows which assistants I have employed oone additional field,…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 43 44 45 46 47 150

Welcome to the Ninox community

Fred

My Posts

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

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: Need help organizing some information

Re: Need help organizing some information

Overview