This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi, community users..I am interested in knowing embed custom html code
an iframe integrated in Appsheet?We want to display 3D models visualize
in a mobile App.Help on this is highly appreciated.Thanks.Dinesh C.
There are lot of problems associated with Appsheet when computing
calculations like invoices return unwanted ZEROS when the quantity is
zero. (If we can stop this zero appear in quantity field we can solve
this issue but since it is a number field, w...
Hi Mark, I found a way to resolve that and the formulas are shared here.
Thanks for your help and guidance. Now I have a clean spreadsheet
without zeros. (If I could not do this properly with expression, I would
have to think of making an Appscript f...
Hi Graham, Yes you have correctly identified that QTY column in number
type actually do not save data on spreadsheet not as zero but as BLANK.
So essentially if that is the case that we need to treat this field as
blank but in number types. I found a...
Hi Graham, Thanks for your suggestion. I had followed that. The
suggested method removes the zeros but creates another problem as all
Totals (where qty is not zero or having >0 value) are now getting zero
values which is wrong. The output right now c...
I am sorry to celebrate early. IF( [qty]=0 , NUMBER("") , [qty]*[price]
) That expression also did not work. ITEM1 ITEM1 DESCRIPTION ITEM1 UNIT
ITEM1 QTY ITEM1 UNIT PRICE ITEM1 TOTAL PRICE ITEM1 DISCOUNT RATE ITEM1
DISCOUNT ITEM1 DISCOUNTED PRICE ITE...
