Moving a row of data from one data source to another

Need help Database
1

Hi everyone,

I’m trying to get lines of data to be moved from one data source “Current Bookings” to be moved to another data source named “Previous Bookings” depending on whether that row of data has now been ticked as complete using a checkbox element in the Table function.

If there is multiple lines of bookings ticked to mark them as complete, I would need them to have their own row of data each in the data source “Previous Bookings” and once it’s been moved from "Current Bookings to “Previous Bookings”, for the original data in “Current Bookings” to be deleted.

Any idea as to what’s the best way to go about this?

Thanks in advance
Lucas

2

This depends on how you structured your database. Do you have two data types for current bookings and previous bookings?

You could have one extra field in the booking datatype i.e. status. You can then make changes if the checkbox is ticked from current to previous.

If you have two separate data types then you have to create a new entry in other datatype and then delete that from the current datatype.

1 Like
3

I have two data types for Current Bookings and Previous Bookings.

I have an extra Column in the Table and extra field in the Current Bookings Datatype with a checkbox to mark as complete or incomplete. Is there any way to have it so that when the user clicks the Submit button it creates a new entry in the Completed Bookings datatype for each individual job marked as complete and then deletes them out of the Current Bookings datatype automatically once they’ve been copied across?

I’ve been playing around with it, but I’m struggling to pull the data across and as separate data entries, it combines them all into one data entry separated by commas instead, which I do not want.

4

As @Nobi said you can add a workflow to create a new entry in the Previous Bookings database reading data from the existing one, and then deleting it from the other one. But I would recommend using stauts, it is more manageable and reduces the amount of WU used.

5

Move it to a single datatype Booking with a status field like other are suggesting, the split datatypes don’t make sense

6

Yes, the status field would be an optimal solution.

7

Thanks for the input everyone, i’ll move it to a single datatype with a status field.

1 Like