Can you demo an admin panel that updates multiple MongoDB collections? Eg a realistic scenario for a moderation panel with separate collections for Reports, Users, Images, and Comments, all linked by identifiers like user IDs and post IDs. I'd love to see how to manage and link these collections effectively in a single admin panel. Thanks!
If you press the delete button on any row, it always deletes the selected record - which is not as expected by the user. So how can I select the row on button press before I run the delete query?
I'm not sure this is supported by Raw commands which Appsmith provides, but one thing that surely works is setting up indexes using MongoDB compass or the Atlas webpage More info on Raw commands docs.appsmith.com/reference/datasources/querying-mongodb/mongo-syntax#docusaurus_skipToContent_fallback
Is there a reason why the connecting of the edit form to the movies list required one to know to use even that simple js to do it? Does the tool not let one "connect" the two more easily? Whether by drag and drop or by an option that has determined the relationship implicitly? Similarly, when creating the input form, you show building it by hand (which seems tedious). Why could it not optionally be built substantially from the edit form that was created? since you chose to generate--not auto-generate--the editor form from a record/document that had all needed columns/data? I'm asking all this as a prospective user. Just learned of the tool. Thanks for the video and other resources, and indeed the tool. :-)
Hey @Charlie Arehart, thanks for your observations! Appsmith is a low-code (as opposed to no-code) tool that is built on the philosophy of providing developers common UI widgets they need to build internal tools. We don't assume too much about our user's intent and provide users with the option to write JavaScript wherever needed to build their own custom Apps or workflows Sure, we're always searching for ways to make the experience more seamless, but we've found that many of our users enjoy the flexibility of customizing their experience with JavaScript, and as a result, we try not to get in the way Please let us know if you have suggestions on improving the experience for everyone. We'd love to hear from you
for those of us in 'enterprise-land' where deleting records is a big no no; on delete can we mark the record as inactive then in get_movies.run fetch only active records?
Hey @NZ, sure! You can have it setup that way so no records are actually deleted. Your get query should contain a filter though to make sure it only fetches the active records
What if you want to query multiple collections and join them together like with a SQL query?
Can you demo an admin panel that updates multiple MongoDB collections? Eg a realistic scenario for a moderation panel with separate collections for Reports, Users, Images, and Comments, all linked by identifiers like user IDs and post IDs. I'd love to see how to manage and link these collections effectively in a single admin panel. Thanks!
If you press the delete button on any row, it always deletes the selected record - which is not as expected by the user. So how can I select the row on button press before I run the delete query?
You could make the trigger based on the triggered row instead of using the selected row bit.ly/docs-triggeredrow
How do I use createIndex to set a unique value constraint? I don't see anything in the docs. On 1.9.16
I'm not sure this is supported by Raw commands which Appsmith provides, but one thing that surely works is setting up indexes using MongoDB compass or the Atlas webpage
More info on Raw commands docs.appsmith.com/reference/datasources/querying-mongodb/mongo-syntax#docusaurus_skipToContent_fallback
Is it possible to connect from Appsmith to Mongo Atlas free cluster M0 Sandbox cluster?? Pls help, am really stuck with an issue related.
Yes sure! The example in the video shows this
Is there a reason why the connecting of the edit form to the movies list required one to know to use even that simple js to do it? Does the tool not let one "connect" the two more easily? Whether by drag and drop or by an option that has determined the relationship implicitly?
Similarly, when creating the input form, you show building it by hand (which seems tedious). Why could it not optionally be built substantially from the edit form that was created? since you chose to generate--not auto-generate--the editor form from a record/document that had all needed columns/data?
I'm asking all this as a prospective user. Just learned of the tool. Thanks for the video and other resources, and indeed the tool. :-)
Hey @Charlie Arehart, thanks for your observations! Appsmith is a low-code (as opposed to no-code) tool that is built on the philosophy of providing developers common UI widgets they need to build internal tools. We don't assume too much about our user's intent and provide users with the option to write JavaScript wherever needed to build their own custom Apps or workflows
Sure, we're always searching for ways to make the experience more seamless, but we've found that many of our users enjoy the flexibility of customizing their experience with JavaScript, and as a result, we try not to get in the way
Please let us know if you have suggestions on improving the experience for everyone. We'd love to hear from you
thanks man i was looking for a video how to create an admin panel instead of making php finally i have done all the CRUD operations. THanks!
Glad it helped! 😇
@Muneeb Ali, can u pls help on the details like which Atlas tier u worked? Is it free M0 sandbox general cluster?
pass the code
👀
so hard to watch this from a Texas
Hmmm, why?
for those of us in 'enterprise-land' where deleting records is a big no no; on delete can we mark the record as inactive then in get_movies.run fetch only active records?
Hey @NZ, sure! You can have it setup that way so no records are actually deleted. Your get query should contain a filter though to make sure it only fetches the active records
@@appsmith thanks - did exactly this and it works nice - low performance hit, works really well.