Hello - I have a site where I allow site members to create paid advertisements. I collect the advertisement information in a custom collection via a form. Each of these draft advertisements are then listed in a table on a page that a member can view and then edit or publish each advertisement. Currently, I have a column in this table with the advertisement ID and when the user clicks the link it opens a dynamic page that allows that single advertisement to be edited.
Next, I’d like to allow the user to select a row (maybe with a checkbox) so that they can publish the advertisement by purchasing a product in my store that provides one month of advertising for that single item. Once the purchase is successful, I’d like to store the advertisement ID, the order ID and an expiration date in another custom table so that I know when the advertisement will “expire”.
I wanted guidance on advice on the best way to go about doing this:
- Is there a way to add a checkbox to a table so that a client can select one item and click the Publish button which then…
- Passes the advertisement ID to the Product Page and then the Cart Page so that I can insert that final set of information into my table that tracks the advertisement ID, order ID and expiration date?
I was trying to leverage the built in Wix Store pages but if it is better to handle all this in custom code, please advise.
Open to any other ideas on how best to accomplish this. Thank you!