I have a Croquet site. I wasn’t able to find a native way to display match dates and times as well as who was playing. So, I improvised using iFrames with a google form and a google spreadsheet that collects the form data.
I was hoping that there was a better integrated method for doing the same as the mobile view of this isn’t pretty, but works in a pinch. Here’s the page if I’ve not clearly spelled out what I’m after: https://www.jacksoncroquetclub.com/events
In short:
The ability to see when others are playing without manual updates (pulled from the form fields)
The ability to sign up to play.
Optional: Ability for anyone to be notified when someone signs up to play.
In the database add fields called Name, Date, Time and More.
Create a page called Book set its permissions to members only and hide it from the menu.
Using user-input elements create a form.
Connect it to the database. (make sure the dataset is set to write-only)
On your Events page add a table from the lists and grids section of the editor.
Connect the table to the database. (make sure the dataset is set to read-only)
Add a button on the Events page and connect it to the Book page you made earlier.
Go back to the Book page in the editor, and change the “when successful, navigate to” to the Events page.
Here’s the dilemma; am I able to have someone to visit the site, plug in their first name, a time, and date, without having to joing/sign up for anything? The rub with the above approach is that we have to use a “members area” where potential guests have to register. I want to circumvent that. Is that possible?
By the way, also note that this post has been added to the feature requests section of the Wix Corvid Forum, which is really to be used for any updates that you wish to be integrated or added to any Wix Update in the future,
You need to place posts like yours into the Community Discussion section which is the main section of this forum for issues related to code on your website.
The Community Discussion section is the one that the Wix Mods and Wix Users check everyday, the Feature Update section may get viewed every so often, however not many people will look in this section for answers to code problems, they will only look for anybody that has requested an update that they want to add already etc or to add their own request with he hope that it gets implemented sometime in the future…
Thanks for the information! I was able to get it implemented and it does indeed look much better. I do have a couple of issues that I ran into however.
Whenever I would attach the time input field to the database, the “Value connects to” item would be grayed out. Support eventually said that tables (or at least the one I chose to use and modify) didn’t support displaying time. There was no warning for that. The work around was to change the field type in the database to text, rather than time.
The next issue was that the table then showed time in military time rather than 12h time as I had selected. After 2 and half hours on with support and being bumped to a higher level of support twice, the rep. said that it was not possible without changing code, but he would put in the feature request. (this is on the Play page)
Lastly, I do not know how to attach trigger the email to be sent to myself (and a few of the other regular players) whenever someone clicks the submit button. The submit butting is only linked to the database. I see if I was using a form, I could easily set the email to come to me as a notification, but I don’t see how to do it with this submit button on the Events page.
If you can shed some light on #3 and if you have any code ideas for #2 so that I can switch back to a dropdown that is time rather than a regular text field, that would be most appreciated. Thanks again for your time in getting me this far. It really does look much better!
