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
Plugins
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
3896
posts
628
likes received
5
followers
Badges
Latest Posts
Re: Changing database icons and colors
When you rename a database you can change the icon and color of the icon. Is that what you are looking for?
Fred
Fred
2 hrs ago
Get help
Reported - view
Re: Hire a person to create templates
You try Ninox's partner website.
Fred
Fred
yesterday
Learn and share
Reported - view
Re: Dynamic Drop Down List sort order? and Pre Select?
Q1: You could create a sortOrder field in the table then you can use the field to sort in any way you want. Q2: You can by just using another text field completely. Q3: This can be done.…
Fred
Fred
2 days ago
Get help
Reported - view
Re: Open child form from table (fill in data) abd return to main form.
@Mel Charles You can also just use the Quotes reference field. no need for a select.
Fred
Fred
3 days ago
Get help
Reported - view
Re: Open child form from table (fill in data) abd return to main form.
@Mel Charles Sorry, I didn't mean to imply that moving openRecord() will change the how the record closes. The issue here is you have created a new record and thus Ninox has moved you to the…
Fred
Fred
3 days ago
Get help
Reported - view
Re: Open child form from table (fill in data) abd return to main form.
Try putting the openRecord() line at the end. You need to allow Ninox to do the copying before you open the record. It is kinda like opening the oven before the soufflé is finished.
Fred
Fred
3 days ago
1
Get help
Reported - view
Re: copy table record with child records to another table record also with child records
@Mel Charles try this: if Pcode then let productRec := record(Products,number(Pcode)) 'Short Description' := productRec.text(Category); Qty := productRec.Qty; Description := productRec.…
Fred
Fred
10 days ago
Get help
Reported - view
Re: Status script not working
@Mel Charles said: So just to be clear you are saying that the [ ] brackets around 'Dispatched' in this case force for the condition of yes/no or true / false or 2/1 (ie look for a ciondition other…
Fred
Fred
10 days ago
Get help
Reported - view
Re: reset/unlink client field (field a) when advicor (field b) is removed
@Samuel Kasper Looks like you are limited to using a button if you want to continue with this data model. The 1 side limitations (no triggers and doesn't register as an action on the record) are…
Fred
Fred
10 days ago
Get help
Reported - view
Re: Status script not working
@Mel Charles I think it is not about the square brackets, but about Yes/No fields. Unless you set to them to a default value of true/false they have a third value of null.…
Fred
Fred
11 days ago
Get help
Reported - view
Re: Parent and Child reUnion
@UKenGB That is why you will have to use an html table and json.
Fred
Fred
2 wk ago
Get help
Reported - view
Re: Parent and Child reUnion
@John Halls Well what do you know, even for tables that don't match fields it works. I don't know how Ninox decides what fields to show or where to put data if the fields don't match but it does.
Fred
Fred
2 wk ago
Get help
Reported - view
Re: Unique transaction Number Not Triggering from Embedded View
@Mehdi Kasiri That is weird. In the public cloud the Trigger on new triggers anytime a record is created regardless from where. I also tried in the app with a local DB and had no issues as well.…
Fred
Fred
2 wk ago
Get help
Reported - view
Re: Parent and Child reUnion
If you are trying to make a new table that is a mix of the parent and child tables then you have to make a new JSON table or actually make a new table. View elements can only take data from one table…
Fred
Fred
2 wk ago
Get help
Reported - view
Re: Unique transaction Number Not Triggering from Embedded View
As @Mel Charles mentions, the other option would be to take over the UI of data entry and your buttons would have the code to make sure data is set properly.
Fred
Fred
2 wk ago
Get help
Reported - view
Re: Unique transaction Number Not Triggering from Embedded View
Is the code in a Trigger on new record? I find that works most often.
Fred
Fred
2 wk ago
Get help
Reported - view
Re: Dashboard not Calculating
@patrick glad it worked out. When you find a moment please mark the post answered. Thanks.
Fred
Fred
2 wk ago
Get help
Reported - view
Re: Dashboard not Calculating
Charts are not very intuitive. I am no expert at them, but I can tell you the basics. The chart field is based on tables so the formula field in the chart has to be a selection of records.…
Fred
Fred
2 wk ago
1
Get help
Reported - view
Re: copy table record with child records to another table record also with child records
@Mel Charles I'm also an amateur. I don't use Ninox for my business just for my hobby. The only issue about referencing the original, especially for quotes,…
Fred
Fred
3 wk ago
Get help
Reported - view
Re: copy table record with child records to another table record also with child records
@Mel Charles Oh, man. You have brought up a can of worms. 😄 If you do a search of copying images, you will see that it is big question. The answer is sadly it is not as easy as saying the image…
Fred
Fred
3 wk ago
Get help
Reported - view
Re: Geschwindigkeitsoptimierung: Große Menge an Datensätzen schneller verknüpfen.
@Reinhard For such technical questions like this you may want to ask Ninox directly.
Fred
Fred
3 wk ago
Get help
Reported - view
Re: Geschwindigkeitsoptimierung: Große Menge an Datensätzen schneller verknüpfen.
@Reinhard said: BUt I, there are about 10k entries per month, so a total of about 70k. Is there a way you can change your work flow so that you work with smaller sets of data?…
Fred
Fred
3 wk ago
Get help
Reported - view
Re: Compare tables
If you feel like your questions have been answered, please take a moment and mark the post answered.
Fred
Fred
3 wk ago
Get help
Reported - view
Re: Compare tables
@horst. droege This is what I get:
Fred
Fred
3 wk ago
Get help
Reported - view
Re: Compare tables
@horst. droege so did my suggestion work?
Fred
Fred
3 wk ago
Get help
Reported - view
1
2
3
4
5
156
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
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