Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
What would you want to trigger copying records?
MuraliGangineni
7 years agoQrew Cadet
I want the trigger to be on click of a button. On clicking the button, delete all the records from the Table2 and copy the records from Table1 to Table2. Before copying, filter has to be applied on "Article Number" column in Table2 based on the Article number present in the record in some other table from where i am clicking the button. Copy only those filtered records.
I know we can use API_PurgeRecords to delete all the records in Table2. But i got stuck at how to copy the filtered records from Table1 to Table2. And that filter on Table1 should be dynamic filter as Article number changes from one record to another record from where i am clicking the button.
I know we can use API_PurgeRecords to delete all the records in Table2. But i got stuck at how to copy the filtered records from Table1 to Table2. And that filter on Table1 should be dynamic filter as Article number changes from one record to another record from where i am clicking the button.