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
Updates & status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Ninox 4
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3939
posts
639
likes received
5
followers
Badges
Latest Posts
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
6 mths 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
6 mths 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
6 mths 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
6 mths 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
6 mths 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
6 mths 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
6 mths 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
6 mths 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
6 mths 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
7 mths 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
7 mths 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
7 mths 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
7 mths 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
7 mths 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
7 mths 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
7 mths ago
Get help
Reported - view
Re: Compare tables
@horst. droege This is what I get:
Fred
Fred
7 mths ago
Get help
Reported - view
Re: Compare tables
@horst. droege so did my suggestion work?
Fred
Fred
7 mths ago
Get help
Reported - view
Re: Compare tables
None of the records Table B field 1 has more than 1 number in it. You make is sound like it could contain multiple sets of numbers, or even an array. If the data in Table B is what it will look like,…
Fred
Fred
7 mths ago
Get help
Reported - view
Re: Compare tables
What kind of data is in field1 from either table? Can you share a sample of the data from each table?
Fred
Fred
7 mths ago
Get help
Reported - view
Re: Geschwindigkeitsoptimierung: Große Menge an Datensätzen schneller verknüpfen.
How many records does this code return? select 'Curve Sales' where Produkte = null Which table is this button located?
Fred
Fred
7 mths ago
Get help
Reported - view
Re: Geschwindigkeitsoptimierung: Große Menge an Datensätzen schneller verknüpfen.
Can you post a DB with sample data? So every 6 months, you import 200K records in a table that you then need to link each record? or you import new records and only those records need to be linked?
Fred
Fred
7 mths ago
Get help
Reported - view
Re: Ninext: bugs & fixes
@Jacques TUR 1) 3.0.4 2) i only have one, so yes 3) No, I am the only user 4) see 3
Fred
Fred
7 mths ago
Plugins
Reported - view
Re: How do you replace a LF or CR?
Hi Holly If you are satisfied with the answer,please take a moment to mark your post answered.
Fred
Fred
7 mths ago
Get help
Reported - view
Re: How do you replace a LF or CR?
try: let crtn := urlDecode("%0A"); Then you can just use the crtn variable to add a carriage return.
Fred
Fred
7 mths ago
1
Get help
Reported - view
1
2
3
4
5
158
Ninox-Website
Overview
Learn and share
Get help
Updates & 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
History
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
Ninox 4
View all topics