Google Sheet Link to Telegram
Status: Closed · Asked by RohitTrader on · 0 views
I am creating a workflow with google sheet such that i have few scripts of share market with price alerts and when the CMP becomes lesser than the trigger level then in the one Column which is also the trigger column of my workflow is changed through a formula. But i am not receiveing message in telegram. I receive message only when I manually change anything in the Column not by formula. How to resolve it
Hey @RohitTrader
I want to clarify that we do not support formulas in the Google Sheets triggers column for workflows in Pabbly Connect. If a formula has been added to the Trigger column, it may prevent it from functioning as expected.
Therefore, I recommend removing any formulas from the Trigger column as we advise our users not to use formulas in the trigger column.
By removing the formula you should be able to ensure that the workflow functions correctly according to your requirements.
Ok actually formula is very much essence of that sheet as that confirms the alert is triggered with the levels I have placed. It actually compares two Numbers one is the trigger level and second is CMP of a Script so is there any other way around to this problem as I have many Scripts and levels in same sheet.
Hey @RohitTraderI want to clarify that we do not support formulas in the Google Sheets triggers column for workflows in Pabbly Connect. If a formula has been added to the Trigger column, it may prevent it from functioning as expected.
Therefore, I recommend removing any formulas from the Trigger column as we advise our users not to use formulas in the trigger column.
By removing the formula you should be able to ensure that the workflow functions correctly according to your requirements.
Thank you for quick response
Actually formula is very much essence of that sheet as that confirms the alert is triggered with the levels I have placed. It actually compares two Numbers one is the trigger level and second is CMP of a Script so is there any other way around to this problem as I have many Scripts and levels in same sheet.
Currently, we do not support formula based updates in the trigger column. I am afraid we don't have any workaround for this concern.
Currently, we do not support formula based updates in the trigger column. I am afraid we don't have any workaround for this concern.
Ok thanks....