Here’s an explanation :
Some customers can create products inside the app (in a Products records database)
Inside there is various field like Name, price, description… and there is Expiration date.
So, when the expiration date is overdue, i want to delete automatically this product, is it possible ?
Or should i use third party app ?
PS: Sorry for my english, i’m french !
PS2 : Adalo is amazing product, keep up in that way and continue to improve your product, there is few things to implement and you will be the best app’s builder !
Do you want delete the data of expired product or just hide at the product list on your app?
If you want hide the information, just change the visibility of data at the list.
If you want to delete the data permanently, you can choice two options.
use the 3rd party app
make a trigger (like a button function) to delete the data. You can setup the filter value to delete only the expired product data when user touch the button.
Hi @MarkC actually i’ve already setup your ideas haha Both of them indeed, list dont show expirate products and inside users account they can edit products and also delete it.
But, to avoid an huge database records, i want to delete product automatically when expiration date is gone
Hello everyone. Can I get some added clarification on this? It appears that the question is can an item be auto deleted after it’s expiry date. The responses seem to revolve around Adalos external API? I don’t think I’m getting it. Is this a workaround? I’d really like a step by step explanation if at all possible. I just can’t seem to wrap my head around it.
I’m afraid that I can’t show you a step by step guide as I’m still on the freemium plan for the time being.
But I can try to explain to you how this would work in a nutshell.
So as @Josselyn was saying, he would like to clean up some space in his database by deleting old records automatically. (this is very useful if you don’t want to exceed your data cap or for other reasons)
To achieve this you can use an API Bridge tool like Zapier or Parabola (also no-code) to build a recurring backend workflow.
The Workflow can do the following:
1: Every day at 12 pm
2: Connect to my app’s database (via the Adalo API)
3: Search for records in my event dataset filtered by current date -1 day (via the Adalo API)
4: Delete the current records (via the Adalo API)
So that’s a backend workflow in a nutshell, hope that’s a bit clearer for you
PS: This isn’t a workaround, all web apps use backend workflows even Adalo.
Yeah, Parabola is definitely for advanced workflows compared to Zapier, I personally use an RPA tool (UI Path) and host all my workflows on AWS EC2 as their CDN is the best .
You use UI Path for workflow documentation or also other tools of it? I have my workflows just documented in MIRO but looking for a more automated tool. I have a EC2, but just running some simple ETL with Parabola + Integromat (We hijacked this topic :D).
It depends on the job, but my most used RPA is Winautomation (recently acquired by Microsoft), I also run my workflows on a T3 EC2 and it cost me about $15/month , can’t get cheaper than that haha.
What’s good with an RPA is that the possibilities are endless, you can have standard backend workflows or full web scrapping bots all running at the same time. Much more powerful than Zapier, Parabola…
Anyway, I’m going off topic, I could talk about RPA’s for hours
I think they’re not using slack anymore. The link in the footer got changed to a link to this forum. However, the link is still at Learn How to Make an App with No Code Tutorials and Resources | Adalo. But it doesn’t work I DM’d Colin and he responded the team will look into it.
et bienvenue au forum!
Both of them indeed, list dont show expirate products and inside users account they can edit products and also delete it.
.
I DM’d Colin and he responded the team will look into it.