Does wpDataTables have the function that after setting formula, I input different quantity, it shows different shipment cubic meter (CBM) ?
Can I set different conditional logic, then I input different quantity, it shows different price? the formula example is like the following: 45KGS below：@$58/KG 500KGS below：@$30/KG 1,000KGS below：@$28/KG
Maybe you can use conditional formatting to solve this. Conditional formatting allow you to change a cell content based on value in the cell so you can set it to show prices instead of quantity - Documentation. So my suggestion would be to create two columns which both will contain quantity but on second set conditional formatting to show price instead
For testing purpose we have sandbox website where you can see and test all plugin functionalities
Does wpDataTables have the function that after setting formula, I input different quantity, it shows different shipment cubic meter (CBM) ?
Can I set different conditional logic, then I input different quantity, it shows different price? the formula example is like the following:
45KGS below：@$58/KG
500KGS below：@$30/KG
1,000KGS below：@$28/KG
They are in the same table.
Thanks for your kind reply.
Hi Kelly,
Thank you for your inquire.
Maybe you can use conditional formatting to solve this. Conditional formatting allow you to change a cell content based on value in the cell so you can set it to show prices instead of quantity - Documentation. So my suggestion would be to create two columns which both will contain quantity but on second set conditional formatting to show price instead
For testing purpose we have sandbox website where you can see and test all plugin functionalities
sandbox.wpdatatables.com
username: demo
password: demo