ContributionsMost RecentMost LikesSolutionsRe: Delete records while adding the records via import from CSVHey Mark, I've had varying degrees of success with this temporary table approach, usually less so when dealing with larger data sets. I've been using automations to try and mark records back and forth so that reactions can drive whether records are copied over. For example (each step is a separate automation): Step 1: data drops into a temp table (this step is a Pipeline/MS Flow step) Step 2: the target table reacts to this and marks any "legacy records" already living in the target table by using a formula field, that concatenates 3 other fields and comparing to a field in the target's key. The target table uses this concatenated field as it's key. Step 3: the temp table will then react and mark records that match in the target table, then delete itself. (This step fails on data sets larger than 1000) Step 4: run a table to table import from temp to target on a schedule after all of those records have finished marking and deleting themselves. These existing records should be unique. (This step fails on data sets larger than 1000) Step 5: Uncheck all Legacy checkboxes in the target table on a schedule. (This step fails on data sets larger than 1000) Maybe I'm making this too complicated, but since this works on data sets smaller than 1000, it feels like I'm missing a simple way to make it all work. In reading your response, I'd love to understand how to "push a button to run a save table to table import from the temporary table into your real table". Since my attempt at automating this task is not working well, maybe a manual approach with actual working steps like yours would be a better place for me to work from. Any help is greatly appreciated! Marc ------------------------------ Marc Barry ------------------------------ Report in Exact form showing default columns onlyHi all, I'm placing a customized report into an Exact form and it will only show the default columns no matter what report ID or name I use. Is there a trick to this other than just using the tildes and a field ID? Any suggestions are greatly appreciated! ------------------------------ Marc Barry ------------------------------ Re: Field Names with BracketsThat did it! Thank you! ------------------------------ Marc Barry ------------------------------ Re: Field Names with BracketsHi Mark, I have a similar issue, where the brackets are in the field name. Here's an example of the field name: 291 Core Subjects EC-6 - 802 MATH- Requires ProctorU LockDown Browser [Total Pts: 40 Score] |289212 I did not include the brackets on either side so you can see the actual field name being imported from an external source. I have another field that simply looks at this field (numeric formula) so I can use it in other formulas. How would escape work with this field? I'd appreciate any help and thanks! Marc ------------------------------ Marc Barry ------------------------------