Fred

San Francisco, USA

3614
570
5

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

My Posts

Latest Posts

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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 mths ago
- Get help
- Reported - view
Re: Help with Creating First Record in Empty Table via Button in Ninox
@iliper LTD If you only have 1 table then there is never going to be an empty table. You have to have 1 record to be able to see the button which means there is a record.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: JSON in dynamic fields
@Sotirios Zormpas Another case would be to make a choice list that is modifiable by end users through a script without having to create a new table.
- Fred
- 7 mths ago
- 1
- Learn and share
- Reported - view
Re: Help with Creating First Record in Empty Table via Button in Ninox
@iliper LTD Sorry, I didn't mean to remove the select. Just retype the whole thing. @iliper LTD said: it is necessary to clarify that a table New Monts report is a subtable in a table EMPLOYEES.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: JSON in dynamic fields
@Sotirios Zormpas Ninox initial response to my question was that they don't support JSON. When I wrote back they got back to me a couple of days ago, which I missed and they said the same thing.…
- Fred
- 7 mths ago
- Learn and share
- Reported - view
Re: Help with Creating First Record in Empty Table via Button in Ninox
@iliper LTD try removing the select and retyping it.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: On the web version (Server 3.14.0), clicking the quick access button causes the page to freeze.
@我是我的我 try removing the Trigger after open script
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: On the web version (Server 3.14.0), clicking the quick access button causes the page to freeze.
@Mel Charles That is the action of the button. delete() then openTable(). I'm using Firefox.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Help with Creating First Record in Empty Table via Button in Ninox
This works for me: let oldData := (select 'New Months Report'); if count(oldData) = 0 then let newRec := (create 'New Months Report'); newRec.('Beg Date' := today()); newRec.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: On the web version (Server 3.14.0), clicking the quick access button causes the page to freeze.
I'm not sure why you want to delete(this) before you want to openTable(). When I run it (also in the public cloud), I get the spinning circle of death. I had to reload the page.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: How can I link 2 separate database?
@Pascal P. It is only available for those with private cloud or on-premise.
- Fred
- 7 mths ago
- Learn and share
- Reported - view
Re: Help needed for dynamic print function
@Johanna Schmidt Fotografie said: stupid Ninox doesn't show data in the preview. Why would it? That would make too much sense, I guess. To be fair, Ninox is not actually processing the template and…
- Fred
- 7 mths ago
- Get help
- Reported - view

1 14 15 16 17 18 145

Welcome to the Ninox community

Fred

My Posts

Re: Help with Creating First Record in Empty Table via Button in Ninox

Re: Dynamic invoices (.docx) with subtable - problem

Re: Help with Creating First Record in Empty Table via Button in Ninox

Re: How to filter selection in dynamic choice field according to selection in another choice field.

Re: Help with Creating First Record in Empty Table via Button in Ninox

Re: JOIN function combine with checkbox.

Re: Merge two tables in HTML and Ninox

Re: Dynamic invoices (.docx) with subtable - problem

Re: Merge two tables in HTML and Ninox

Re: Dynamic invoices (.docx) with subtable - problem

Re: Dynamic invoices (.docx) with subtable - problem

Re: JSON in dynamic fields

Re: Help with Creating First Record in Empty Table via Button in Ninox

Re: Help with Creating First Record in Empty Table via Button in Ninox

Re: Help with Creating First Record in Empty Table via Button in Ninox

Re: JSON in dynamic fields

Re: Help with Creating First Record in Empty Table via Button in Ninox

Re: JSON in dynamic fields

Re: Help with Creating First Record in Empty Table via Button in Ninox

Re: On the web version (Server 3.14.0), clicking the quick access button causes the page to freeze.

Re: On the web version (Server 3.14.0), clicking the quick access button causes the page to freeze.

Re: Help with Creating First Record in Empty Table via Button in Ninox

Re: On the web version (Server 3.14.0), clicking the quick access button causes the page to freeze.

Re: How can I link 2 separate database?

Re: Help needed for dynamic print function

Overview