Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
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.
Mike_N
10 mths 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.
Mike_N
10 mths 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.
Mike_N
10 mths ago
6
replies
129
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.
Mike_N
10 mths 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.
Mike_N
10 mths 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.
Mike_N
10 mths 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.
Mike_N
10 mths 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.
Mike_N
10 mths 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.
Mike_N
10 mths 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.
Mike_N
10 mths 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.
Mike_N
10 mths 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.
Mike_N
10 mths 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.
Mike_N
10 mths ago
19
replies
461
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.
Mike_N
3 yrs ago
1
Get help
Reported - view
Mike N.
Mike_N
14
2
0
Joined: 10 Oct 2019
Follow
Home
Learn & Share
Get help
Webinars
View all topics
Tags