
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 21, 2022 03:25 PM
For this retail example, I am importing sales data into a Sales table, which automatically updates the Inventory table. Here’s what I want to solve for:
As file is being imported into Sales table, check productID against Inventory table to see if productID exists, if it does not, do not import.
Thanks for your help!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2022 12:45 PM
Hi @Shawn_Titus
How are you importing the records?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2022 04:19 PM
Right now, by csv. I’m willing to consider other options in order to discard those unwanted rows, as long as it’s not manual!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 23, 2022 04:33 PM
Ok, one thing you can do is create a view where, productID is blank, and then just bulk delete those imported rows or you can remove them prior to import in excel with a macro.
If you are comfortable with javascript you can review the scripting block input.fileAsync where you can scrub the file before adding the records.
