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
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3810
posts
606
likes received
5
followers
Badges
Latest Posts
Re: Create an Array from a dynamic Choice field
You are very close. Since you have var a, you don't need var aa. You need to reference your loop variable that references the ISTRUTTORE record that you selected in ISTRUTTORI.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@RoSoft_Steven I thought I've tried that and was unsuccessful, but if you vouch that it works then I agree that this the way to go.
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: if statement in choice field for dynamic printing
Cause I haven't done this before, I thought I would figure it out in Carbone. It could look something like: {d.rights:ifEQ(Yes):show('Yes Text'):or(.rights):ifEQ(No):show('No Text'):…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@Johanna Schmidt Fotografie JSON is just a way of organizing data, kind of like creating a table on the fly. You have a key or field names (the name to the left of the colon) and the value or data…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: if statement in choice field for dynamic printing
The easy way is to just add it to your JSON. usageRights: switch text(Rights) do case "Yes": "This my my Yes text." case "No": "This my my No text." case "Limited": "This my my Limited text." end
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@Johanna Schmidt Fotografie Produkt is a reference field, so you can pull any fields from it. Try adding the field name you need.
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@Johanna Schmidt Fotografie here is what it should look like. You just use the new names exactly as you typed it.
Attachment
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: BugReport: Cannot access ChildObject if it has same name as parent
email Ninox directly or post on the German version
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Change the color of Number text(field) depending from the value
@George Tanev take a look at the styled() docs.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Change the color of Number text(field) depending from the value
If you are in form view then there is no way to change the text color, even manually, in a number field. If you are in table view then you can add a conditional format rule to the column for Number 1.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How can I calculate which week of the month a specific day falls into in Ninox?
@Alain Fontaine Just letting people know that is what happens. So they shouldn't be surprised when they see a 6th week.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Copying files
are the files in an image field or in the attachment section of the record? Also take a look at Jacques' post about copying files.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How can I calculate which week of the month a specific day falls into in Ninox?
@Alain FontaineJust an FYI, Ninox's week starts on Monday and ends on Sunday. So any month starting on Sunday (i.e. Sept 2024) will have 6 weeks according to this formula.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How can I calculate which week of the month a specific day falls into in Ninox?
@我是我的我 I originally thought like you did, that there can be 5 weeks in a month. And that does make things complicated. But since you asked for monthweek,…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How can I calculate which week of the month a specific day falls into in Ninox?
@我是我的我 Can you expand on your thinking?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@Johanna Schmidt Fotografie Sadly there isn't if you DO NOT use custom JSON. When you create your JSON to iterate through Zusammenfassung you need to do something like: let t := this; t.…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: How can I calculate which week of the month a specific day falls into in Ninox?
Could you do something like: switch true do case day(DateField) < 8: 1 case day(DateField) > 7 and day(DateField) < 15: 2 case day(DateField) > 14 and day(DateField) < 22: 3 case day(DateField) > 21:…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
I also noticed that you have many field names with spaces in them. That means you will need to get comfortable with creating JSON datasets. You can practice by creating a new formula field and put…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
Ok, try the attached docx file. You tried: {d.Zusammenfassung.Artikel[i].Leistung} but it should be: {d.Zusammenfassung[i].Produkt.Leistung} In the Rechnungsposition Hochzeit table the reference…
Attachments
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Merge two tables in HTML and Ninox
@Christoph Hintermüller Is Nr the german version of Id? If it is then you can use Nr.
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Merge two tables in HTML and Ninox
@Christoph Hintermüller Looking at other posts (1,2) about ui.popupRecord() I see that it needs the nid of the record to work. A nid consists of tableId and recordId,…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Help with Creating First Record in Empty Table via Button in Ninox
@Fred But in this case you don't need the select as New Months Reports is a child table of Employees, so you can just use the reference field name. let oldData :…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@Johanna Schmidt FotografieIn the MacOS app: open the DB click on Table menu and select Export data click on Ninox (third option after CSV and Excel) click on Save as button select a location and a…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Help with Creating First Record in Empty Table via Button in Ninox
@iliper LTDBoth the select() and create() commands looks at the table name not the reference field name so it should read: let oldData := (select 'New Monts Report') let newRec :…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How to filter selection in dynamic choice field according to selection in another choice field.
@Michal Bor said: instead of recoding names in the WORKING HOURS table it records numbers in fields EMPLOYEE and SHOP. Is there a reason why EMPLOYEE and SHOP are not reference fields?…
Fred
Fred
1 yr ago
Get help
Reported - view
1
21
22
23
24
25
153
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
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
View all topics
