Fred

San Francisco, USA

3400
539
4

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

My Posts

Latest Posts

Re: Sort json?
Thanks@Jacques TUR . I was hoping for something simple and you have provided. I did not know you could add order by to the end of a for loop. Here is the final code: let getData :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sort json?
@Rafael Looks good. I need to sort not search.
- Fred
- 1 yr ago
- Get help
- Reported - view
Sort json?

Hi everyone - I'm trying to create an HTML table but want to be able to sort it, probably by using a choice field that would modify the order. I can't just sort the select because one of the fields…
- Fred
- 1 yr ago
- 11replies
- 203
- Get help
- Answered
- Answered
Re: Printing a VIEW ? This is how it can be done:
@RoSoft_Steven said: this will not be deducted from your monthly dynamic print allowance (100 for starter and 500 for professional) Sadly, I get dinged for each test print. Luckily I don't do any.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Share Ninox database to another account
Depends on how "trusting" of your brother you are. What level of license do you have? Sadly, Starter level doesn't let you download archives of your DB from the browser. Weird.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to make a dashboard display values per calendar week?
The MacOS app allows pivot tables. So if you use the app then you can watch this video for a bit of background.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to make a dashboard display values per calendar week?
@Filip Serica said: Is there maybe an easier way with some pivot tables? How do you use Ninox? app, public or private cloud? If Public cloud then you need a Professional license for Pivot tables.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to make a dashboard display values per calendar week?
Well I had to try it out and with very basic HTML skills I came up with: The numbers below each month are room numbers. I repurposed a hotel reservation DB.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to make a dashboard display values per calendar week?
I think you will have to use html() function to be able to get what you want. Check out this post for more info. This will allow you to recreate the excel look of having a category with subcategories.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Mirror tables in different databases
There are two ways to update tables in different DBs. 1) If you have a private cloud instance then Ninox has built in tools to talk between DBs. I am so hoping this comes out in Public cloud.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Printing a VIEW ? This is how it can be done:
It is weird. I tried it on another DB and it took over 2min before the PDF popped up. I tried it in your DB and the PDF showed up within seconds. My main DB does not create the PDF at all.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Printing a VIEW ? This is how it can be done:
@RoSoft_Steven do you find it easier to use custom JSON then just the Ninox field names? One one table, I'm just trying to get a simple field: {d.CurrentTeamName} and when I click on print nothing…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Reset line id to 1 with new invoice
This numbering is very simplistic. If you ever delete any records this method does not track the deleted number so you could have skip numbering, or you could have duplicates (if the last record was…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Reset line id to 1 with new invoice
bink inkel said: 3 Tables: HOME where I enter the date, INVOICE, where i enter customer info, and LINE ITEMS. That is an interesting idea. So you would enter in a record in HOME that would store the…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Reset line id to 1 with new invoice
How do you create your line items? From Invoice? From a dashboard?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sum service amounts from three tables based on dates
You can take advantage of the power of relationships by changing your code to: let a := this; let s := sum(Earnings[Payday = a.Paydate].'Total Net'); let v := sum(Tracking[Payday = a.Paydate].…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Sum service amounts from three tables based on dates
It took a bit for me to find the picture. It is in the Contractors table not the Earnings table. Also Paydate is a date field not a formula field. So I modified the code in Payment field to: let a :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sum service amounts from three tables based on dates
@Shawna said: The picture shows the Earnings Table. So you have a view element called Earnings in the table called Earnings? @Shawna said: Paydate is a formula field.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Run a fórmula under two conditions
@Rafael If it is just for you then you don't have to switch just remember that you can't select more than 1 milestone.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Run a fórmula under two conditions
So are you saying the following code doesn't work? if Real1 != null and Milestones = 1 then (first((select Milestones where Id = 1).MLT) * Hours) / 100 end Maybe put numbers() around Milestones so…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sum service amounts from three tables based on dates
The picture in your original post is from which table? Is Paydate a date field? What kind of field is Payday in the other tables? I don't think John is saying your formula doesn't work.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Admin Column Filters overriding individual user filters. Can I prevent this?
Sadly you can't set filters of columns in table view to be browser based. That is why you should consider setting up Pages, as fields can be set with Binding:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Thoughts on a DB redesign

Hi all - So I've been developing my team show jumping DB the last few years quite organically. I knew almost nothing about setting up a DB when I started and had zero knowledge of DB coding.…
- Fred
- 1 yr ago
- 23replies
- 341
- Learn and share
Re: Ninext project
@Jacques TUR We all wish other software developers were as responsive. Thanks, Jacques, for making Ninext an indispensable toolkit.
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Ninext project
@Jacques TUR I tested it out in a copy of the Ninext db you have posted and it works fine copy/paste from a table to a Page. But copy/paste doesn't work if I have a dashboard with no table view.…
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view

1 53 54 55 56 57 136

Welcome to the Ninox community

Fred

My Posts

Re: Sort json?

Re: Sort json?

Sort json?

Re: Printing a VIEW ? This is how it can be done:

Re: Share Ninox database to another account

Re: How to make a dashboard display values per calendar week?

Re: How to make a dashboard display values per calendar week?

Re: How to make a dashboard display values per calendar week?

Re: How to make a dashboard display values per calendar week?

Re: Mirror tables in different databases

Re: Printing a VIEW ? This is how it can be done:

Re: Printing a VIEW ? This is how it can be done:

Re: Reset line id to 1 with new invoice

Re: Reset line id to 1 with new invoice

Re: Reset line id to 1 with new invoice

Re: Sum service amounts from three tables based on dates

Re: Sum service amounts from three tables based on dates

Re: Sum service amounts from three tables based on dates

Re: Run a fórmula under two conditions

Re: Run a fórmula under two conditions

Re: Sum service amounts from three tables based on dates

Re: Admin Column Filters overriding individual user filters. Can I prevent this?

Re: Ninext project

Re: Ninext project

Overview