I have a file i want to import via FTP, that file has a column called Stock #, i then have a status in my application not in that file that i want to update. But i only want to update records that have matching stock # to the ftp file. So if the import comes and sees that the numbers match than i want to change the status . Is this possible?
Yes, you'll need to learn about Triggers and the Server-side API to do this. The best approach is to write an Object Script trigger that finds the record(s) you want to update and then performs the update.
See Chapter 6 for more info on Server-side API
See Chapter 10 for more on Triggers
https://www.rollbase.com/rollbaseinaction.shtml