Skip to main content

Ninox-Documentation

Fred

Fred

San Francisco, USA

2880
435
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: Calculate the percentage if this result is negative
@iliper I like the more common sense approach.
- Fred
- 21 hrs ago
- Get help
- Reported - view
Re: Regarding 'history' issues.
One possible solution is to use a dashboard for your users to modify data. I think it is best not the let users modify the raw data directly. Then with the click of a button you can make your own…
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Search formula fields in another table
If you feel like the post has been answered please mark the the post answered.
- Fred
- 2 days ago
- Get help
- Reported - view
Re: Search formula fields in another table
Take a look at the attached DB. The big change is the new Readings table and data subtable. There is also the Systems table with the attached subtables as well.…
Attachment
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Sharing DB ISSUES
What hasn't been updated in over a year? The app or the DB you created? Are the techs using the browser or the app. Which version of the app are they using?
- Fred
- 3 days ago
- Get help
- Reported - view
Re: Deleting a column??? How???
Are you asking how to remove a column from a View form or view element? Or do you want to delete the field that the column is based on? To remove a column from a view,…
- Fred
- 3 days ago
- 1
- Get help
- Reported - view
Re: Search formula fields in another table
@Angel Del Pino VelezThanks. What is your experience with databases or programming? I'm guessing the headers are different categories that need to be tracked as well?
- Fred
- 3 days ago
- Get help
- Reported - view
Re: How to disable Create Record button in reference
@VermajiWhat version of the app are your running? Does this happen to any DB on your Mac? You should probably email Ninox support about this.
- Fred
- 3 days ago
- Get help
- Reported - view
Re: About the issue of allowing edits only when conditions are met…”
@我是我的我 once you get one user worker working, you may want to think about creating groups and using groups in your permissions. That way when your business grows you don't have to keep modifying the…
- Fred
- 3 days ago
- 1
- Get help
- Reported - view
Re: Calculate the percentage if this result is negative
@iliper LTD The original post asks to check for negative. Does that part work? Now you are having problem figuring out the discount? What kind of field is Customer?
- Fred
- 4 days ago
- Get help
- Reported - view
Re: About the issue of allowing edits only when conditions are met…”
@我是我的我 said: (Or is there a better way to achieve this effect?) Yes there is. Try not to mix security/permission with DB structure design. You can view this video to give you the basics on role based…
- Fred
- 4 days ago
- 1
- Get help
- Reported - view
Re: About the issue of allowing edits only when conditions are met…”
FYI, when you want to do a report on all orders your current setup will make it difficult to script as you have to get data from different tables. What happens when you add a new sales person?…
- Fred
- 4 days ago
- Get help
- Reported - view
Re: How to disable Create Record button in reference
@Vermaji said: Is it possible in Ninox to export a particular table from a database and import that table with data or just the structure into another database.…
- Fred
- 4 days ago
- Get help
- Reported - view
Re: How to disable Create Record button in reference
You did ask this: @Vermaji said: Can someone please advise how can we do the following: 1. Disable the little "+" sign in the reference field on the form for local Mac app version.…
- Fred
- 4 days ago
- Get help
- Reported - view
Re: How to restore Ninox database from Time Machine
I recommend you email Ninox support.
- Fred
- 5 days ago
- Get help
- Reported - view
Re: Create new record with outside button
@iliper LTD I don't see the field 'Choice' in the code. If the choices in the two choice fields have the same choice numbers and text then you can try: newRec.( 'List of Customers' := t; Choice := t.…
- Fred
- 5 days ago
- Get help
- Reported - view
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
- 5 days ago
- Get help
- Reported - view
Re: How to disable Create Record button in reference
Check out this post.
- Fred
- 6 days 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
- 6 days 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
- 6 days ago
- Get help
- Reported - view
Re: Calculate the percentage if this result is negative
@iliper LTD Can you post your code?
- Fred
- 6 days 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
- 6 days 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
- 6 days 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
- 6 days 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
- 8 days ago
- 1
- Get help
- Reported - view

1 2 3 4 5 116

Back to top

Ninox-Documentation

Overview

View all topics