AnsweredAssumed Answered

not show negative price

Question asked by hunterkilla on Jan 21, 2016
Latest reply on Jan 22, 2016 by Mike_Mitchell

I have an excel spreadsheet with delivery costs and some of the costs come back as a negative number so technically we dont have to charge extra to deliver.   I intend to import this about once a month into filemaker overwriting the current price.     I want it so when someone chooses there delivery options if its a negative it just automates it to put 0 and then if its a actual charge to put that in... so is there a way to script if delivery = - then make it 0 else do delivery charge?

Outcomes