Telgram summary report

AppSheet AppSheet Q&A
, ,
1

I want to use the Telegram API to send a summary similar to a pivot table, but my formulas are not working properly. I want to create the summary based on Date, Channel, and Quantity, where the Date is equal to today and the Quantity is summed channel-wise. This summarized data should then be sent to Telegram as a daily summary.

{
  "chat_id": "-1001665429950",
  "text": "šŸ“Š *Daily Campus Scan Summary*\nšŸ—“ *Date:* <<TODAY()>>\n\n*CHANNEL WISE SUMMARY:*\n--------------------------\n<<Start: SELECT(SCAN SHEET[FLYER NO], AND([DATE] = TODAY(), [FLYER NO] = ANY(SELECT(SCAN SHEET[FLYER NO], AND([DATE] = TODAY(), [CHANNEL] = [_THISROW].[CHANNEL])))))>>\nā— <<[CHANNEL]>>: <<SUM(SELECT(SCAN SHEET[QUANTITY], AND([DATE] = TODAY(), [CHANNEL] = [_THISROW].[CHANNEL])))>>\n<<End>>\n--------------------------\nšŸ“¦ *Grand Total Qty:* <<SUM(SELECT(SCAN SHEET[QUANTITY], [DATE]=TODAY()))>>"
}

I WANT THE RESULT IN A TELEGRAM MESSAGE IN THIS FORMAT

CHANNEL QTY
AJIO 25
AMAZON 36
FLIPKART 24
NYKAA 26
TOTAL 111
2

When you say your formulas are not working, do you mean your quantities are incorrect or that you are getting errors?

2 Likes