Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Mike N.

Mike_N

14
2
0

Joined: 10 Oct 2019

My Posts

Latest Posts

Re: Comparing Multi-Selects
@Fred "Though what you wrote for a and b look to be the same thing. You have no table name in front of the field name in a and you put this in front of the field name in b and that is the same thing.…
- Mike_N
- 2 yrs ago
- Get help
- Reported - view
Re: Comparing Multi-Selects
awesome, and Yes, my multiple choice field has 7 items and I need to allow for all possible combinations, including where nothing is selected. I'm used to thinking in terms of loops and was planning…
- Mike_N
- 2 yrs ago
- Get help
- Reported - view
Comparing Multi-Selects

Looking for help on how to compare two multi-selects. Specifically, I need to return a true result when none of the options in the second list are selected in the first list.…
- Mike_N
- 2 yrs ago
- 6replies
- 240
- Get help
Re: Complex Select statement for View
@Fred so how do I put the results (array) back into a table? If I just delete the concat statement the table (view) is empty.
- Mike_N
- 2 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
@Fred Thanks Fred! I'd actually progressed with my solution where I created several functions which return a boolean and serve as filters to narrow down the data,…
- Mike_N
- 2 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
OK, updated database attached. restating the rules for compatible actions as methodically as I can: 1. Rule out all actions which have the same actor as the current action. 2.…
Attachment
- Mike_N
- 2 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
I probably could have done a better job picking my examples, but assuming you made the two changes I mentioned yesterday in Parts Set Compatibility table (Lower parts - Gimbal should also be…
- Mike_N
- 2 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
I put the example together a little too quickly and missed checking a couple compatible parts sets with the Parts Set Compatibility record. Lower parts - Gimbal should also be compatible with Lower…
- Mike_N
- 2 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
@Fred Oh, there were no down arrows on the database icons until I tapped on one. Thanks for your help with that Fred! Database attached. Within the Actions table there is a view with no formula,…
Attachment
- Mike_N
- 2 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
@Fred Thanks, again, I am using the IOS version. Within the database inside the tables list there is an export option which lets me export as a csv, excel format, or Ninox.…
- Mike_N
- 2 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
@John Halls So happy you're willing to look at this! I can't share the actual database but I could pretty easily create a simplified version with just the parts within this scope and share that…
- Mike_N
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Complex Select statement for View
I left something out and I couldn't figure out how to edit my post, so I'm appending this: There are only three Entities, therefore, an Entity can't be engaged in more than two actions.…
- Mike_N
- 2 yrs ago
- Get help
- Reported - view
Complex Select statement for View

Summary of what I need to do: I have a table called Actions within which I am trying to create a view of all actions which are compatible with the current action.…
- Mike_N
- 2 yrs ago
- 19replies
- 811
- Get help
- Answered
- Answered
Re: Creating many to many relationship between two tables
I have to say that the example could be a lot better. While it describes the basic database structure, it doesn't address how you would set up the fields or views in order to make working with this…
- Mike_N
- 5 yrs ago
- 1
- Get help
- Reported - view

Back to top

Overview

View all topics