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: Filters - product filtration
@iliper LTD The searching part is easy. Like I said earlier, I created the fields SearchTerms and Formula in their respective tables to make an array of all selected choices.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: JSON in dynamic fields
@John Halls said: is that it gives the ability to have different dmc values for different records in the same table, which might not be correct. Never thought of that. As you say it works.…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Filters - product filtration
You should be aware that dynamic choice fields selections are "remembered" by Ninox even if you change the selection. If you select Gender under Filter and then select Male.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Filters - product filtration
@iliper LTD Take a look at the attached DB. A few changes: 1) added a field called SearchTerms in Products. It creates an array of the selection(s) from Filter and Categories.…
Attachment
Fred
Fred
1 yr ago
Get help
Reported - view
Re: JSON in dynamic fields
Looks like there is difference between how you build your JSON that affects the ability of Ninox to use text(). This code works: for i from 1 to 13 do { id: i, caption: text(date(2024, i,…
Fred
Fred
1 yr ago
1
Learn and share
Reported - view
Re: JSON in dynamic fields
@RoSoft_Steven Here is my json code: let originalFruit := split(originalChoices, ", "); for i in range(1, count(originalFruit) + 1) do { id: i, caption: item(originalFruit,…
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: JSON in dynamic fields
@RoSoft_Steven I'm in public cloud, so yes. Here is what it looks like:
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Filters - product filtration
Here are my suggestions: In the Products table: 1: change the code for Filter dynamic choice to: record(Filters,1).Filter_Name It looks like Filters is a dashboard or the beginning of a modular table.…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: JSON in dynamic fields
@RoSoft_Steven I don't see any changes. when I do text(dMC) I get a blank formula field. If I do just dMC then it shows the selections. If I do debugValueInfo(text(dMC)) it shows string("").
Fred
Fred
1 yr ago
Learn and share
Reported - view
Re: Warning of dynamic multi choice bug
Once they get the new JSON dynamic choice fields fixed maybe that will make dynamic choice fields more dependable. Or maybe Ninox really only intended dynamic choice fields to be a UI element and not…
Fred
Fred
1 yr ago
1
Learn and share
Reported - view
Re: Release notes
This is awesome! Thanks for putting this in the forum. Can I request that you start adding what changes were made with x.x.1 updates?
Fred
Fred
1 yr ago
Service status
Reported - view
Re: Multiple users to enter data
There are no free accounts in Ninox. If you have a public cloud stored DB then each user will need a subscription. It could be a starter account, but you will need to pay for each user that you want…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: copy part of a table on a new subtable
@Cirugia Toracica I’m not sure what you mean by: @Cirugia Toracica said: not able to copy an specific field value without creating a new field. Can you post a sample DB?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Store generated PDFs
@Alina Morgovsky Glad to hear you have a solution. If you can provide a brief summary of what you did and post the code that you ended up with that would be very helpful for others who come upon this…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Questions Regarding Bugs in the New Mac App and the Windows Version Release
You should email Ninox. They don’t check the English forum as much as they do the German one.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Store generated PDFs
@Alina Morgovsky You could modify your GENERATE button in the first screenshot to create the new records. Do you need help with that code? Can you post the code you have so far that is not working?…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Store generated PDFs
You probably want to create a new table that stores just your printouts. From what I've seen on Nioxus' webinars is they don't link their document table to any other table.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Importing QuickBooks transaction report to create tables in Ninox
Can you post a two record sample of your data? One record with out the split and one with?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Problem Dynamic Print Layout - iteration
@gaetan if everything is working, please mark this post "Answered".
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Duplication when importing products
You are saying: if not existingRecord then doesn't work. You can try: let existingRecord := (select '3_Article' where 'Article No.' = articleNo); if count(existingRecord) = 0 then If that doesn't…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: In a dynamic print it is possible to format a number
You can also format in Ninox as you create your JSON, to make the coding easier on the Carbone side.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: In a dynamic print it is possible to format a number
Yes, you can format numbers in Carbone. Looks like they can even do currency conversion for you. Don't know where they get their rates from, but kinda cool.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Problem Dynamic Print Layout - iteration
Can you post a sample DB?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Thoroughly delete image elements with code
@我是我的我 Well Ninox says: To fully clear the file reference from an Image field, you need to manually set that Image field to null using scripting, such as: removeFile(Image); Image := null;…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Problem Dynamic Print Layout - iteration
@gaetan That is the Ninox code to make the JSON. Put this code in a formula field in the same table as the dynamic print and copy a bit of the actual JSON code that is produce.
Fred
Fred
1 yr ago
Get help
Reported - view
1
20
21
22
23
24
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
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
