Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Plugin apps
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3831
posts
614
likes received
5
followers
Badges
Latest Posts
Re: About batch write Questions
@我是我的我 said: I just didn't know how to use the "item" function. Just to make things clear, what francesco wrote is a for loop command. for [loop variable] in [array] do end So what you referred to as…
Fred
Fred
2 yrs ago
2
Get help
Reported - view
Re: About batch write Questions
Is the data in 1 just text separated by a paragraph mark? Is the table in 1 related to the parent table or child table in 2? 1 中的数据只是由段落标记分隔的文本吗？ 1中的表与2中的父表或子表相关吗？ Hope the translation is ok. :)
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Single Dynamic field that populates other fields
@Mel Charles said: I just need to monitor the performance on this lookup tho... verses have a sub table to select the contact! You made a good start by using the reference field to create the dynamic…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Single Dynamic field that populates other fields
@Mel Charles said: The first one goes in and is accepted but it returns an email that is not associated with the customer contact Yes, well I was wrong about the root of EContact.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Single Dynamic field that populates other fields
Have you considered using the record() command? I don't know if EContact pulls from the Customer table (it looks like it does), but if it does you already have the appropriate recordId.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
@Dave Irving said: Here is the script for that "Days Since Last Contact" field. I replaced 0 with null, but that broke it. So if you want xCurIndex to be null then you have to think the opposite.…
Fred
Fred
2 yrs ago
Get help
Reported - view
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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs ago
Get help
Reported - view
Re: Split Function Help
what kind of field is Genre in the Masters table?
Fred
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs ago
Get help
Reported - view
Re: Relationship between 2 tables - how to?
@Kruna always nice to have a functional example not just words.
Fred
Fred
2 yrs 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
Fred
2 yrs 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
Fred
2 yrs 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
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
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
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
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
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
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
Fred
2 yrs ago
Learn and share
Reported - view
1
69
70
71
72
73
154
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugin apps
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
