Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Get the number of the chosen entry in a Dynamic Choise field
@Haavard Hjorteland said: My goal is to create a "Next" button and "Previous" button, so I dont have to use the combobox, if i just quicly want to scroll through the list.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Create new records with a button
@German Caldera yes you can delete data entry. but if you are creating a db for other users you may want to consider creating Pages that users use instead of inputting data directly into your tables.…
- Fred
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
@Dave Irving Approaching this another way, can the code for 'Days Since Last Contact' be changed to use a null value instead of 0? That way you can include it in any function and it won't be counted.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Create new records with a button
I also created a button in Ordenes de Compra called add Items and it will add items to the current record you are on.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Relationship between 2 tables - how to?
You need a many to many (N:N) table between Saster and Herlev Seniorkor. Maybe it can be called Songs Rehearsed or Rehearsal Songs? Anyways, create a new table then add the relationship field to…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Create new records with a button
I did a slightly new flow. I created a new Page called Data Entry. There you will see a list of Proveedores. You will see two fields with one that shows all related Articulos and another that shows…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Create new records with a button
@German Caldera Ok, so I changed Art0 to look directly into Articulos. Play around to make sure it pulls the correct records.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Create new records with a button
Take a look at the first record in the Ordenes de Compra table. At the bottom are two new fields, Compras with Proveedores (ComprasProv) and Articulos greater than 0 (Art0).…
- Fred
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
@Dave Irving said: However, it has to not count that first Chrono in the record because that value is 0 and throws the avg off since there are obviously a couple thousand chrono records with 0.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Create new records with a button
@German Caldera If you have access the MacOS app you can create an archive: open your DB and enter admin mode select the table name at the top left select Table from the app Menu Select Export data >…
- Fred
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Re: Create new records with a button
Can you upload a sample DB with sample data?
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Math formula with exponents
Have you looked at the Ninox docs? Granted they are usually not very good, but they do talk about powers.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Printing a VIEW ? This is how it can be done:
@RoSoft_Steven yeah, sadly we will never find out when they do. it is so frustrating that they are so bad about communicating fixes.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
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
- 2 yrs ago
- Get help
- Reported - view
Re: Sort json?
@Rafael Looks good. I need to sort not search.
- Fred
- 2 yrs 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
- 2 yrs ago
- 11replies
- 220
- 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Learn and share
- Reported - view

1 69 70 71 72 73 153

Welcome to the Ninox community

Fred

Re: Get the number of the chosen entry in a Dynamic Choise field

Re: Create new records with a button

Re: Need Script for calculating workdays between 1st record, 2nd record, so on.

Re: Create new records with a button

Re: Relationship between 2 tables - how to?

Re: Create new records with a button

Re: Create new records with a button

Re: Create new records with a button

Re: Need Script for calculating workdays between 1st record, 2nd record, so on.

Re: Create new records with a button

Re: Create new records with a button

Re: Math formula with exponents

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

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:

Overview