Fred

San Francisco, USA

3743
594
5

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

My Posts

Latest Posts

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
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 1
- Learn and share
- Reported - view

1 34 35 36 37 38 150

Welcome to the Ninox community

Fred

My Posts

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

Re: Formulate View field from multiple date entries?

Re: Triggers and table conditionals limitations in Local/Cloud

Re: Is it possible to add a condition at the beginning of the table?

Re: Formulate View field from multiple date entries?

Re: Triggers and table conditionals limitations in Local/Cloud

Re: Is it possible to add a condition at the beginning of the table?

Re: Triggers and table conditionals limitations in Local/Cloud

Re: How I write long blocks of code

Overview