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
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3605
568
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: How do I create a new database using the custom tables created by me in another database?
When you open the app or login to the website you will see your DBs, if you hover over the top right corner of the DB icon you will see a drop arrow. If you click on that you will see the option to…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Views are not saved when I close database
Make sure you are in Admin mode (red wrench is active) before you make any changes.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Spam = Garbage = Not Good!
Amen. I email them every time spam shows up. If we all did....
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Retrieve data from a table and display them in other table
Hope you are able to find this amongst the spam. How long has Ninox said they would fix this? Anyways, back to your question. First I'll start with a few of my own questions: 1) just to sure,…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Does a button only work once ?
I can't think of any, but there are smarter people out there. Does anyone know of the secret self-destruct code? :)
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Does a button only work once ?
It all depends on the code. What is the code?
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Code to Generate PO Numbers
I look forward to seeing some ideas around auto-increment the next letter. I've seen numbers but not letters. For the other part you will have to take your date field and create three formula fields…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Holiday day alert
Hi Rob - I don't get any dialog to show up if I put in the Trigger after update. I can get alerts to show up but no dialogs. I'm using the MacOS app. If I put it in a button then dialogs work.…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Automatic record creation
Nice. Will have to remember that.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Automatic record creation
Try this in a button first: let curRec := this; <--gathers data from the current record in Table1 if Field1 > 0 then <--checks to see that Field1 is greater than 0let xT2 :…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Count similar records in same table
Hi David - Can you give us a sample of your code you are trying to use?
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: How can I have a formula that counts records from a table?
p is a variable to store the data that you are looking for. In the second line it should read cnt(select [Table Name] where [field name] = p) <-- replacing Table Name and Field Name with your…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Holiday day alert
Please post the code you are using.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Holiday day alert
Please post the code you are using.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Jan Laan
To be clear, when you select, for example, choice1 from your dynamic choice field that is on your invoice table it copies over data from your products table like name and price in your invoice table?…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Odd Database behavior
Is DB2 an exact duplicate of DB1, with just different data? Which means all of the tables are named the same and the only thing that has changed is the data in the tables?
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: How can I link 2 separate database?
The easiest way would be to create a reference field in your table that tracks time and labor to your customer table. It will default name the new field to your customer table name but you can rename…
Fred
Fred
4 yrs ago
Learn and share
Reported - view
Re: Link record n:1
nice. didn't know that was possible.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Need to Match show rows from a table if email field matches
I was wondering if your code was correct but it isn't. Please change it to: select Events where EmailTo = me.WorkEmail or EmailFrom = me.WorkEmail You were basically saying if EmailTo equal anything.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Need to Match show rows from a table if email field matches
Are you using email fields or text fields for EmailTo and EmailFrom?
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Need to Match show rows from a table if email field matches
Please double check the record for 20 Apr 2021, 05:08 to see that the email address is not in either Emailto or EmailFrom.
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Link record n:1
Hi Andrea - In your first post you stated that you have a field called FirstTable, so I'm guessing that is the reference field in SecondTable linking it to FirstTable.…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Need to Match show rows from a table if email field matches
a bit of background to Fabio's great suggestion: Your code was just missing a way for Ninox to access the current record you are in. Thus the first line of code is to tell Ninox to take the data from…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: Link record n:1
What do you mean you want to do it in reverse? If it is a 1:N then wouldn't you always be in your FirstTable and be creating records from there, letting Ninox create the links for you?…
Fred
Fred
4 yrs ago
Get help
Reported - view
Re: What happens in "Crash"
Wow, that does not sound good. What is the script you are running?
Fred
Fred
4 yrs ago
Get help
Reported - view
1
132
133
134
135
136
145
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
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