Olá, gostaria de saber se é possível fazer com que um bot mande uma notificação popup sempre a data de vencimento de uma parcela de empréstimo vencer.
A ideia é que seja automático, ou seja, não seria necessário abrir o app para checar.
Já tentei uma ideia que tive, que era programar um bot para atualizar uma coluna periodicamente com os valores dos status: A vencer, Vence Hoje, e Vencido. Mas esse tipo de bot não funciona no plano gratuito, então nem é possível testar para ver se funciona.
AppSheet is not a “proactive” app, it requires interaction for things to happen.
So the only way to get a popup, is for a user to have clicked on something. You can, however, sneak things into the tap events for everything - so if you need to, you can sneak in some Alert action notifications throughout your app.
This way when a user taps on, say an Order record to view it’s details, technically there is a stack of actions kicking off; the first is an alert-style action to provide your alert (or you might use INPUT(), if you needed to gather info or confirm something), then the next is the normal navigation action that takes the user to the details of the record they just tapped on.
If no alert is required, the user has no idea that anything was skipped over.
Now if you’re just wanting some sort of notification, you could use an automation to:
Send a push notification (user must have app installed on device)
Send an email/text
Send a webhook to other service
In regards to free: you’ll likely have to pay for it, but $10/month for your own use of X apps that you can build is a pretty small price for the power you get.
