Liangxie
Qrew Cadet
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Move Records with API Buttons in Quick Base
This is what I want to do 1. I have one table has couple options 2. there is another table like create a PO 3.I want make one button on the option table, and pick couple options which I need copy to another table into one PO ------------------------------ Liang xie ------------------------------16Views0likes1Commenthow to write the fumule
Hello Can i get help? I'm going to setup a report as blow: Customer Date Press Type Press Serial Number Sell Price Factory Cost Ocean Freight Duty Inland Freight Total Landed Cost Grossç Gross Margin % only thing i need help is how create a single gross profit report by a customer (specific order number)? It would show: Sell Price $xxx,xxx Factory Cost $xx,xxx Ocean Freight $xx,xxx Duty $xx,xxx Inland Freight $xx,xxx _______ Total Landed Costs $xxx,xxx Gross Margin $xxx,xxx Gross Margin % xx.x% ------------------------------ Liang xie ------------------------------Re: really needs help about the forluma
It looks not work. If bill of landing is not blank, do tracking, or show "not ready yet" If(Trim([Bill of Landing No.])="", Case([Carrier],"CMA","http://www.cma-cgm.com/ebusiness/tracking/search?SearchBy=Container&Reference="&URLEnco... of Landing No.]), "COSCO","http://elines.coscoshipping.com/NewEBWeb/public/cargoTracking/cargoTracking.xhtml?CARGO_TRACKING_NUM...; &URLEncode([Bill of Landing No.])&"&REDIRECT=1&uid=" ),"Not ready Yet")7Views0likes0Commentsreally needs help about the forluma
I'm wirting a forluma just can not figure it out, I just try, if Bill if landing No. is not empty(Bill of landing No. is TEXT), then do connect with the tracking web, or just show "not ready yet" Can you help me about it If(not Is Null ([Bill of Landing No.]), Case([Carrier], "CMA","http://www.cma-cgm.com/ebusiness/tracking/search?SearchBy=Container&Reference="&URLEnco... of Landing No.]), "COSCO","http://elines.coscoshipping.com/NewEBWeb/public/cargoTracking/cargoTracking.xhtml?CARGO_TRACKING_NUM...; &URLEncode([Bill of Landing No.])&"&REDIRECT=1&uid=" ))