Fred

San Francisco, USA

3616
571
5

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

My Posts

Latest Posts

Re: Relationship between 2 tables - how to?
@Kruna always nice to have a functional example not just words.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Get the number of the chosen entry in a Dynamic Choise field
Haavard Hjorteland said: symbol expected do, symbol excpected end and end excpected case at line 5. oops, yes just add do to the end of switch Beboer_Sortering do Haavard Hjorteland said:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Get the number of the chosen entry in a Dynamic Choise field
Haavard Hjorteland said: The list can be long, as pr. now close to 100 in some occations, so Radio button take up to much space. Wow that is a long list.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Create new records with a button
Can you upload a sample DB with sample data?
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 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
- 210
- 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

1 61 62 63 64 65 145

Welcome to the Ninox community

Fred

My Posts

Re: Relationship between 2 tables - how to?

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

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

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?

Overview