How to clone table

[Balaji Munusamy]

My requirement is clone table and export all records into the new table. For example: The main table is 'incident' i want all the fields and records from incident table and to be inserted in 'New table'. And if new record created in 'incident' table it should insert the same record into the 'New table'.

@Sohail Khilji @Ankur Bawiskar @Community Alums 

[Ankur Bawiskar]

@Balaji Munusamy 

Thank you for marking my response as helpful.

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.

[Balaji Munusamy]

Hi @Ankur Bawiskar 

can you help me with the flow or script for when new record created in the main table that should reflect in the 'New table'.

[Peter Bodelier]

Hi @Balaji Munusamy,

Can you first please explain exactly why you would need this?
I believe there would be better solutions than doing this.

[Balaji Munusamy]

Hi @Peter Bodelier,

Let me explain you clearly. The Main table is being used  by everyone in our organization and our team is using specific filters in that table as we work on it. We don't want to disturb the main table that's why we need an  exact replica of this table. If we make any changes, it won't affect the main table.

In the main table, there are over 300 fields along with numerous business rules and scripts. Creating a new table with same fields manually is time-consuming. That's why I'm asking if there's an alternative way.

[Peter Bodelier]

I really don't understand why this would disturb anything.

But in any case, there is not way to do it easily, you'll need to create it by scratch.

As Ankur already said it should be easy to create the records, by simple using create record in flow designer, after you created the table.