Best way to save user's edits as unpublished and then publish live?

Need help Database
1

Hi all,

I’m building a landing page builder and need to save the current user’s edits they’ve made to a landing page and then allow them to publish these edits to live for public view.

What’s the best way to store edits and then mark them as “live” when publish is clicked?

(Custom states won’t seem to work as new things are being added to the database such as primary options and sub-options).

Thanks

2

I would do this through the database. I would save the edits to a different data entry and then when the user clicked “publish” I would copy the edits to the live version.

4

I was thinking of this approach.

How would I go about copying database type: “unpublished” to a new database type: “published”?

Thanks

5

Make a workflow with a data make changes to a thing action.

6

Sure, but it would be a list of database items to copy over. Would that need to be done in a backend workflow?

7

Without knowing your database and app structure I cannot say for sure if you will need a backend workflow or not.

If I were creating it from scratch I would have 2 different data types. One for published and one for editing. They would be linked to each other and then I would just copy from the editing to the published on button click. No backend workflow needed. If you have a list of data to change you will probably need a backend workflow.

8

Was hoping I wouldn’t have to go the backend workflow route, but looks like I might need to.

Thanks!

9

Ended up using List Shifter plugin - works like a charm.

1 Like
10

This topic was automatically closed after 70 days. New replies are no longer allowed.