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: Private Server
Ninox does have a private cloud option which is what the Connect to server... is for. This is where a company installs a multi user version of Ninox on their own hardware or Ninox hosts it for them.…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Unique Value Formula
@RoSoft_Steven Thanks for lumping me in with @Jacques . Most of the time I’m just drafting in his wake. @Mel Charles , this site is good to test your RegX code. I haven’t found a good RegX tutorial.…
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: Need Help with view table.
One way is to hide the view until there is something in the search fields. Another way is in the switch command there is a “default” case, so you can try putting null in there.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: How to create records automatically
in the example you give, is there 15 records in the expiry table for customer AZName Ltd? So there is a N:1 relationship between Expiry (many) and customer (one) and a N:…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: How to create records automatically
@webmaster.antonioferriero said: Can you create such a button? With which code? You can do most things in Ninox. My little brain is having a hard time generalizing your workflow.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: How to create a unique list of records
Well @Jacques, your code makes a lot of sense and is much easier to use.
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: How to create a unique list of records
I’ve wanted to do something like this for about a year now.
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: How to create records automatically
@webmaster.antonioferriero said: Question. How to associate Fulfillment to each Customer? In other words, how to fill the Fulfillment table? Are you starting in the Fulfillment table,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Dynamic Choice Field Assistance
Glad to hear it works for you. Please remember to mark this post answered.
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Dynamic Choice Field Assistance
Once you start working with multiple choice fields (regular or dynamic) then you can't use the equal sign so easily. Once a record in WFM Permissions has more than one option selected in the multi…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Send email and include only fields with value
@Bernd Krell said: With 2 or 3 empty lines between, it looks odd. Any way to prevent this? I would say to play around with putting the carriage returns in the check formulas,…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Dynamic Choice Field Assistance
Are Eligible Departments and Eligible Titles multi choice fields (thus the use of numbers)? Can thisuserdepartment and thisusertitle have more than 1 record?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Tables sync
great to hear. You are on your way to master Ninox! Just remember to mark the post "answered".
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Tables sync
@pirinisz said: Yes but in a formula there is no grading by date I have no idea what "no grading" by date means? Since the date field in Table A is a date field.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: Sorry man, the date field is actually a simple date field, not a reference. Refer back to my original reply about creating a formula field as your Date field for Table B.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: On Table B I have 2 references (one for name and one for date) Are your two reference fields pointing to Table A?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: OK but I don't get to see the date field this way.... I thought you were going to use a formula field? Another way is, you can add the date to the Show data as formula:…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: I added in the "trigger after update" the following code: if today() > 'date' then 'date' := date(year(today()) + 1, month('date'), day('date')) end Ninox has pretty nice date data…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: Could you please explain to me with more details the following, according to the values I gave you? In Table B, open Edit Fields. On the right side of the window is a section called…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: But I noticed that I have to close and reopen NINOX in order to synchronise, right? Which version are you using, cloud or MacOS app?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: After that, I will have to change some values on field Y (dates) in Table A. How will I change the links to field Y on table B automatically??? If you set it up,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Proper Case code sample
what about the length function? let desLength := length(DESCRIPTION) DESCRIPTION := upper(substring(DESCRIPTION, 0, 1)) + lower(substring(DESCRIPTION, 1,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Tables sync
I can’t tell if your “links of X and Y” are regular fields or reference fields. Ninox does linking of records differently than other DB apps. It links at the record level.…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Structural Problem - How to choose multiple items to add to an Invoice?
@Kent Signorini said: One thing I'm struggling with in my own syncing implementation is I'd really like to generate an array of IDs for Items NOT checked off in the Dynamic Multiple Choice field.…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Copy Yes/No function value
@ekalcasino777 said: it seems to me that the best solution for us is to simply copy all the table data "GM TABLE" the next day. Do not copy it partially, but the all table.…
Fred
Fred
3 yrs ago
Get help
Reported - view
1
102
103
104
105
106
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
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics