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: How to locate N:1 relationships that contain data?
@我是我的我 Just to be clear you wouldn't use both systems. But for testing, you just need to change the People link in subOrder.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to disable Create Record button in reference
Check out this post.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Create new record with outside button
Take a look at your hotel DB. Isn't there a button that creates records in other tables?
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: How to locate N:1 relationships that contain data?
@我是我的我 said: Could you share the two approaches of not creating and creating? Take a look at the attached DB. You can see how much simpler Formula 2 is compared to Formula.…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Calculate the percentage if this result is negative
@iliper LTD Can you post your code?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Search formula fields in another table
Wow, 50 fields and 50 formula fields. That is a lot. May I recommend that you check out this post. Cause searching 50 fields is a big pain the butt. In short,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to locate N:1 relationships that contain data?
Are you trying to figure out if a reference field has a link? And if it does then to use that link? Will there be times that more than 1 reference field is used? Could all three be used?…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Calculate the percentage if this result is negative
Try the sign() command. if sign(RESULTS) = -1 then [code] end
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Triggers and table conditionals limitations in Local/Cloud
@cor said: In local, new records are NOT automatically filled with that linked information from parent tables. I'm not sure I understand this part. If I'm on MacOS app with local DB.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Field label on the form different than the field name in the database
Seems like this is answered in your other post.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to adjust what is returned from a link to another table
@mark. robinson When you get a chance please mark the post answered. Thanks,
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to adjust what is returned from a link to another table
@Sotirios Zormpas I love all the different solutions that are offered. I like this idea too.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: how to adjust what is returned from a link to another table
@mark. robinson said: I've tried testing this by just putting "None" in the coding area, but the field remains blank. So my second objective might be unachievable You are correct if trying to do it…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Formulate View field from multiple date entries?
@James Just a bit more background. Ninox runs on records. Anytime we do a select or access reference fields we are getting back records. So in the Fitting table we are looking for data across two…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Triggers and table conditionals limitations in Local/Cloud
@cor Yes, the pages issue is old. But go ahead and tell them. The more the merrier. Just don't expect Ninox to tell you when they fix something. You just have to remember to test it out in new…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Is it possible to add a condition at the beginning of the table?
@我是我的我 Sorry for not providing a possible solution to your question. You can do something like this in your column formula: let x := invoiceitems; let y := for loop1 in x do if loop1.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Formulate View field from multiple date entries?
@James I don't know what to say. I have this (thanks to eagle eyed @Sotirios Zormpas ) in the Date Search tab: let xbeg := 'Start Date'; let xend := 'End Date';…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Triggers and table conditionals limitations in Local/Cloud
@cor said: These options are available only in Pro subscription. I missed this part of their website: So yeah, Starter does not have Role-based access permissions.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Is it possible to add a condition at the beginning of the table?
@我是我的我 It is possible to do it in the column formula, just easier as a formula field.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Triggers and table conditionals limitations in Local/Cloud
@claudio. orI was able to add isInAdmin() to Creatable if, both local and web, and it worked fine. I have v3.12.2 MacApp and the latest for the web. I am in the Pro subscription (😫).…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How I write long blocks of code
With a bit more work, I'm down to 271 lines. I can probably cut it down even more, but it is taxing on my wee brain.
Fred
Fred
2 yrs ago
1
Learn and share
Reported - view
Re: Triggers and table conditionals limitations in Local/Cloud
Here is the official word on those permissions. There shouldn't be any difference between apps and not mention of subscription level. I guess I would want to know what your code is for the ifs.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Is it possible to add a condition at the beginning of the table?
It would be easier to write a new formula field in the invoiceitems table that does checking. Then you can just reference the new field in your column.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Formulate View field from multiple date entries?
@Fred I tested it again on a local DB and it worked, but only after I noticed that you are using a different view element. I wrote the code for the Fitting Appointment view element on the Fitting…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Formulate View field from multiple date entries?
@James said: However I just copied your code and put it in but it still doesn't work. I've just taken 2 screen shots to show you. I don’t know what to say, but it works for me.…
Fred
Fred
2 yrs ago
Get help
Reported - view
1
42
43
44
45
46
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