Fred

San Francisco, USA

3380
533
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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths 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
- 6 mths ago
- Get help
- Reported - view
Re: How to restore Ninox database from Time Machine
I recommend you email Ninox support.
- Fred
- 6 mths 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
- 6 mths 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
- 6 mths ago
- Get help
- Reported - view
Re: How to disable Create Record button in reference
Check out this post.
- Fred
- 6 mths 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 mths 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 mths ago
- Get help
- Reported - view
Re: Calculate the percentage if this result is negative
@iliper LTD Can you post your code?
- Fred
- 6 mths 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 mths 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 mths 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 mths 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
- 6 mths ago
- 1
- Get help
- Reported - view

1 19 20 21 22 23 136

Welcome to the Ninox community

Fred

My Posts

Re: Calculate the percentage if this result is negative

Re: Regarding 'history' issues.

Re: Search formula fields in another table

Re: Search formula fields in another table

Re: Sharing DB ISSUES

Re: Deleting a column??? How???

Re: Search formula fields in another table

Re: How to disable Create Record button in reference

Re: About the issue of allowing edits only when conditions are met…”

Re: Calculate the percentage if this result is negative

Re: About the issue of allowing edits only when conditions are met…”

Re: About the issue of allowing edits only when conditions are met…”

Re: How to disable Create Record button in reference

Re: How to disable Create Record button in reference

Re: How to restore Ninox database from Time Machine

Re: Create new record with outside button

Re: How to locate N:1 relationships that contain data?

Re: How to disable Create Record button in reference

Re: Create new record with outside button

Re: How to locate N:1 relationships that contain data?

Re: Calculate the percentage if this result is negative

Re: Search formula fields in another table

Re: How to locate N:1 relationships that contain data?

Re: Calculate the percentage if this result is negative

Re: Triggers and table conditionals limitations in Local/Cloud

Overview