Fred

San Francisco, USA

3400
539
4

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

My Posts

Latest Posts

Re: Split Function Help
@francesco.stefanello Thanks. It is interesting that your code uses html() twice. I would think you would only use it once, but it works. Playing around I was able to remove the html() from the loop…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Split Function Help
@RoSoft_Steven I have this: let list := split(Text, ", "); let content := join(for i in range(0, cnt(list)) do "<span onclick=""ui.openRecord('" + raw(first((select Table1)[Country = item(list, i)]).…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Split Function Help
ui.popupRecord does not work for me. Did Ninox finally remove this feature? @francesco.stefanelloare you using the MacOS app or the browser?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Split Function Help
@francesco.stefanello you didn't misunderstand me. It is just my feeble mind that couldn't figure out that there are smarter ways of getting data.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Split Function Help
@francesco.stefanello wow so you manually type in the genres? may I ask why you don't make it a dynamic multiple choice field?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Split Function Help
what kind of field is Genre in the Masters table?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
Dave Irving said: However, still need to not include the 1st chrono record for all leads so we can remove the 0 values from the equation. This code might work.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Relationship between 2 tables - how to?
sc said: I understand that I need a many to many relation, but I'm uncertain how to create it in Ninox. did you seeKruna fine example of a N:N table? The table is called chose songs and it is…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Spinning circle most of the time
For me I seem to get it most during the weekend. I'm guessing you have a pro license or even higher and that is troubling. I only have a starter so I put up with a bit more hassle.
- Fred
- 1 yr ago
- Get help
- Reported - view
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

1 52 53 54 55 56 136

Welcome to the Ninox community

Fred

My Posts

Re: Split Function Help

Re: Split Function Help

Re: Split Function Help

Re: Split Function Help

Re: Split Function Help

Re: Split Function Help

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

Re: Relationship between 2 tables - how to?

Re: Spinning circle most of the time

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:

Overview