I am building an Event Management app (for internal users only) that has nothing to do with actually scheduling or user enrollment of the event (we want to handle that with our CRM), but rather management of the sessions (where users are assigned to attend, not self- enrolled etc), so its akin to a Conference Agenda app. I have yet to figure out how to integrate with the CRM backend (tables, etc) for this question, let’s just assume a single, event-specific Sheet (DB) with multiple sheets (tables) is generated for use and editing by event-specific (not organization-specific) admins. Let’s also assume that the CRM (website) will take users to the correct “instance” of the event app.
This awesome how-to How to use Security Filters to allow multiple companies to use the same appfrom @MultiTech is in the general vein of what I want to do, however,
- there will never be users or events (companies in the tutorial) added from the app (the CRM will always handle both of these tables)
- not a problem- just skip that part of the tutorial1. There is nothing confidential in which we need to shield users from Event 123 from seeing Event 789, thus complex security features/filters are not needed
- However, it will be just best practice that a user needs to be in the user list for an event to have access to it1. user roles for the same user may be different for different events
- ie, John Doe is an admin for Event 123, but just a standard user for Event 2381. Datasiurces will pre-exist as “templates”, which again, the CRM will handle
- The tutorial was not clear in how it handled all of the data coming in from different companies running the app, however:
- Mixing data into master tables from different companies (or in my case, events) is just unwieldy and a complete non-starter (I’m not meaning to suggest this was recommended anywhere)
- Mixing tables from different (yet similar) Events would be equally unwieldy as we are taking a couple hundred events annually
At the end of the day, the logical programmatic perspective would be to:
- store variables in the App as placeholders to point to a different datasource(s)
- I do not believe that AppSheet provides this functionality for datasources?
- pass values (from website/CRM) into said variables upon invocation
- I have now discovered that there is an AppSheet API, but in the little help I have found (admittedly not much time spent doing so), I am not even certain that this will provide what I am looking to do?
While this post may have been wordy (not sure why my indented sub-bullets have an extra line spacing?), I don’t believe what I am trying to achieve is really too far out of expectations for what should be a functional application of the tool. Any help here is greatly appreciated.
). I certainly did not mean to imply that anything is actually being done directly in a Sheet (there is zero intention of anything being done there). My inference that a single datasource becomes unwieldly is rooted in the fact is that not only is there literally zero value in different events data being stored together, and that doing so only adds potential confusion as each event (table) has multiple sessions (rows) that are a repeat for each and every event. To clarify, they are not identical rows as they will have subtle differences (durations, exact start times, etc) but there is absolutely zero value in the same session for XX events to be in the same table. The same holds true for the event attendees (table) and is even worst since user roles for the same user may be different for different events (ie, John Doe is an admin for Event 123, but just a standard user for Event 789). If we are successful in creating a live/dynamic link back to our CRM, this part goes away.
