Skip to main content
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
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3375
533
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths 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
2 mths ago
Get help
Reported - view
Re: Help with Creating First Record in Empty Table via Button in Ninox
@iliper LTD said: table New Monts report is a subtable in a table EMPLOYEES So the reference field is called New Months Report, but that is not the actual table name.…
Fred
Fred
2 mths ago
Get help
Reported - view
Re: JOIN function combine with checkbox.
You can use the new function in dynamic choice fields. Create a JSON of your data following a particular format and you are ready to go.
Fred
Fred
2 mths ago
Get help
Reported - view
Re: Merge two tables in HTML and Ninox
@Christoph Hintermüller Please mark the post answered when you have a moment.
Fred
Fred
2 mths ago
1
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@Johanna Schmidt Fotografie Are you using the MacOS app? or the public cloud? If the cloud then which level did you subscribe to?
Fred
Fred
2 mths ago
Get help
Reported - view
Re: Merge two tables in HTML and Ninox
I think you might need to change: let combinedEmails := emailSchreiben + emailVerwaltung; to let combinedEmails := array(emailSchreiben,emailVerwaltung); When you create the two JSON variables,…
Fred
Fred
2 mths ago
2
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
Oops, I was wrong. Here is what works for me when I want to use data from a reference field inside a reference field. {d.ProductionItem[i].Materials.Name} {d.ProductionItem[i+1].Materials.…
Fred
Fred
2 mths ago
Get help
Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
Try: {d.summary.article[i].product} {d.summary.article[i+1]}
Fred
Fred
2 mths ago
1
Get help
Reported - view
Re: JSON in dynamic fields
@Sotirios ZormpasPlaying around I figure out this long way. I start with five items. formula field that builds my JSON a text field called originalChoices a text field called newChoice a button a…
Fred
Fred
2 mths ago
1
Learn and Share
Reported - view
Re: Help with Creating First Record in Empty Table via Button in Ninox
@iliper LTD said: I need a button that will create a first record in the table new month report If this button is in the New Months Report table then the button can not create the first record.…
Fred
Fred
2 mths ago
Get help
Reported - view
Re: Help with Creating First Record in Empty Table via Button in Ninox
@iliper LTD I'm confused about what you want done. Can we start over? Please describe the tables/fields involved and the process you want to happen. Or upload a sample DB with the proper tables.
Fred
Fred
2 mths ago
Get help
Reported - view
1
4
5
6
7
8
135
Ninox-Website
Overview
Learn and Share
Get help
Service status
Documentation
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
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
