ContributionsMost RecentMost LikesSolutionsbuttons to copy a table to another table and edit the original tableI have Table A which includes the current billing cycle for our jobsite. And table B is the archive table for all the previous billing cycles. What I would like to do is have a button on table A's page somewhere that allows someone to archive Table A to table B ( aka just copy the contents and paste them into table B) I then would like a different button on Table A's page that changes the current billing cycle based on the value in Table C. Ideally, it would replace the old billing cycle id with the new one, and then I need to go one step further and clear the hours worked from the previous billing cycle(percentage per project in my case). I have already thought about the functionality of archiving it and just keeping it in the same table, but I don't see an easy way to copy all the fields from the previous billing cycle into the same table with a new billing cycle id. My fear is that I would end up copying all the records in that table and would create duplicates of people on specific projects for a new billing cycle. I have thought about the possible headache any changes in the table would bring, but I can't imagine it being too bad, or likely to change. Thanks everyone!populate multiple items for fields for multiple selected fieldsSo currently I am creating a billing app, and the way you have to go about inputting information for an employee is you select their employee info and the project they were working on and allocate a percentage for each week for that specific project. What I would like to do is instead of having multiple entries for a single employee, I want one entry where I can populate for multiple projects and percentages for those projects. Projects is currently its own table. % per week allocation are just fields in the main table. Is there a way to do this? Or do I have to enter each project separately for each employee? The most efficient way to enter data now is to search for the specific employee profile and then grid edit so you can go across multiple projects in one screen. Example: Employee A worked on projects 11 and 12. For week 1, they worked 50% on P-11 and 50% on P-12%, week 2 they worked 25% on P-11 and 75% on P-12... and so on and so forth. Also another question is there a way to set a requirement on this form where they cannot overallocate a project (aka be more than 100% for that week for all projects), currently my workaround is a separate table where I take in summary fields to check for the errors and highlight them. I also added a filter to make it easier, but functionality wise it would be best if you wouldn't have to go back and forth between the forms to check and fix issues with the allocation. Thanks!