ContributionsMost RecentMost LikesSolutionsRe: Building an Importer - Pipeline Thanks for the reply! I am trying to avoid importing if the unit already exists. I was planning on using that unique id to be the indicator to know if it is in my "Units" table or not. I know I will end up having duplicates in my "Import" table but only want one in the target table. ------------------------------ Ryan Broderick ------------------------------ Building an Importer - Pipeline I have data (Individual Units/Jobs) scrapped from builders' websites and want to import it into a specific table. I have built an "Import" table because I want my pipeline to check for duplicates before it imports into my "Units" table. The data that I scrap often is the same + new units. After checking for duplicates I want it to only import the unique or new units. Does anybody have a good reference to help, or know how I should build my pipeline? I assume I need to start with an import then run a query on the import table and the units table, and then create based on not finding any that match a specific field that is the "SKU" for the unit. ------------------------------ Ryan Broderick ------------------------------ Re: Update field with most current data from another related table.I forgot to note that you will basically tell the pipeline to add/or update whatever field you want when a change is made. Or you can set it up when new values are added. Whatever works best for your situation. ------------------------------ Ryan Broderick ------------------------------ Re: Update field with most current data from another related table.Hi Kathy! I have been building on Quickbase for only a few months now but to me it seems like a simple pipeline would work. I don't know if you have started playing with them but there are some good resources on the University. You could tell the pipeline to update the fields in the table with the most recent values added. The pipelines are fairly user friendly. Hope this helps! ------------------------------ Ryan Broderick ------------------------------