Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #3576574
Interactive Tables
Closed

Comments

  • Ali started the conversation

    I'm looking for a table to host on my website, with my full repertoire list for my couples to look through. I have an Airtable one at the moment, but their pricing structure is not applicable to my usage and I need to move away from that. If I can move so it is all integrated into my website that would be good. My couples, are like my team in that I want them to be able to interact with the table, and select the pieces of music they would like, and for which aspects of the day.

    So the data is the song list. Currently I set up a new field for each couple, and they have a list of selectable options (pre-ceremony, ceremony entrance, ceremony exit, drinks reception, etc) which they can select for each song they are interested in.

    But they're clients not employees hence most hosted database solutions are not applicable for me. I'm currently also exploring Spreadsheet and Baserow, but these again are separate hosted solutions. I'm looking for something I can actually put in my website behind a password, that allows folks to interact on an editor-level basis with the table.

    I can just use a plain table and provide a link to the interactive one, but I'm exploring all the possibilities. I'm not clear from your demo's as, once again, most people's usage of these things does not resemble my own. Is it possible to create interactive databases in this plugin, or is it just for creating tables of info for customers to look through?

    Many thanks

  •  1,694
    Miloš replied

    Hello,

    To begin, I want to extend my heartfelt apologies for the delayed reply, 

    which is due to an unexpectedly high volume of inquiries. 

    We truly value your patience during this period.

    -

    I am sorry, but i did not fully understand all the details/points of your Use-Case.

    It seems it might be a simple use-case or perhaps having one "main Table" which holds all the data that only the Admin can see, and then for the Front-End users, you can add an SQL Query Table which will pull from the main Table, but you can limit what each User can see - such as if you need each User to only see the Rows they added, not see other people's rows, etc;

    but i am not sure what you mean exactly when you say it should be 'interactive databases'.


    Can you please elaborate in more details on that aspect of the Use-Case, if you can provide me with an example, what should a User see when they visit their Table, what functionalities should happen, should they simply just edit their own rows ( while just seeing the rows they added), or is there some more advanced functionality needed?


    You can start by checking out our Editable Tables here.

    Then, if you need to make Foreign Key Relations between multiple Database Tables, you can check this Feature.

    And here you can see our Feature to limit the Rows, so that each User can only see and edit their own rows ( which they added).


    Let me know how that seems to start with, and then if you can elaborate more about the Use-case, if you can add any screenshots as examples or a Video?

    If you show any sensitive Data, just make sure to mark the reply as PRIVATE for security reasons;

    or if a Video gets too large, you can upload it to weTransfer and send a download link.


    Thank you.


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables