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 All,for appsheet sample order capture ,is there way to get filter the
products table in a slice so that expired products or zero qty products
only get shown if the transType = "return" , but if transType = "sell" i
get products filtered.cheersEmad
Hi all,how to use start: expression for both rows and columns in
appsheet , for example to calculate items sold per month in columns and
items in rows, the columns should be added only if items sold exist in
that month.cheers
Hi All ,my app was working fine till this afternoon , nothing is changed
, the pdf files created in google drive and i can open it from there ,
but not in app.any idea? is there a change in appsheet or google
restrictions somehow implemented?cheers
Hmmm Probably your did not understood my question, any way , i don’t
need the documentation as I already build many apps to generate pdf‘s
with start expression.cheers
Hi not really What i am asking is about <>
<>and <> <>how can you combine both
to put in a pdf , so that the column is dynamically created like the row
in pdf.As an example:SUM <> <> (row)months where
items were sold:<> <> (column)btw I asked chatGP...
1- add column2- add action to create pdf
(concatenate("Files/",UNIQUEID(),".pdf"))3- open fileI had one issue
with file path as it get created in sub/sub folder to , I truncate the
file at creation time , hope this could help.cheersEmad
HiWhat i did is create a column that hold the invoice number in the
order table and used the value as file name when saving to drive.once
the file was save an action to open the file used same value.