Fred

San Francisco, USA

3701
591
5

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

My Posts

Latest Posts

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

1 32 33 34 35 36 149

Welcome to the Ninox community

Fred

My Posts

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

Re: Field label on the form different than the field name in the database

Re: how to adjust what is returned from a link to another table

Re: how to adjust what is returned from a link to another table

Re: how to adjust what is returned from a link to another table

Overview