Just to note, the Microsoft Dynamics team is offline and have to be signed in to our Wi-Fi to get on it, would it still be able to do Microsoft Data Calls and Webhooks?
@muellerme
You should contact Bubble Support and ask them to waive the extra WU consumed by your application for this month.
They would most probably do it for you once in a lifetime and they will ask for your approval, and once your approve by email, they won’t charge you for the extra WU consumption for this month.
Also I would suggest that you “disable overages” so that you never face an unwelcomed situation although your app will be down if you finished all your WU within the billing cycle / month.
Hope this helps !
1 Like
I hope they abandon the per WU cost. I say this because they target the platform at no coders and non-technical people who will never understand the consequence of how they build stuff.
The reports are nice, but there’s nothing that can help most non-technical users understand what a workflow, action, trigger etc will cost.
Either that, or everything that happens on dev should be completely free. Only production WU’s should be billed for. That might help some people see how many WU’s something they built will consume before pushing it to prod.
I only had one overage, and it was due to a “workload spike” at 3am that I could not trace back to any real usage of my app. Checked all my other stats (clarity, google analytics) and there was no indication of what happened. Support couldn’t find anything either so I just had to suck up a $150 extra charge.
4 Likes
Totally understood! I wanted to mention you could actually add these just for this month and then downgrade agai - just to save that cash this month.
2 Likes
I mean, I explained to them the situation. I do hope for them to waive it this once, but I never expected it in the first place. Yes for now, will disable overages, so this doesn’t happen again. Thanks for the advice!
I can see how it can be punishing on not tech-savvy people. I, for one, am tech-savvy, but unfortunately it all came to me at once. I saw the workload spike prompt on the top-right hand corner and when I click it just see the WU metrics fly through my monitor.
What would be really nice if somehow bubble.io can recognise that a workflow will take a lot of WU units before initialising it and give a warning prompt.
Hi there, I am sorry this is happening to you! Oddly, I am experiencing the same thing as of last night and this morning. I disabled overages and still racked up hundreds of dollars in overage charges. I am not even able to figure out what is causing them. I am not super tech-savvy so any advice is appreciated on where to look into this. I’m not sure exactly what to be looking for and server logs didn’t show anything that looked odd to me. I reached out to support and they are looking into it. I also noticed on the status page there are issues with the Main Bubble Cluster today. Do you think that would have anything to do with it?
Probably not
If you got to your app’s logs, you can view a donut chart showing which parts of your app consumed all of the WU. If you post here, we can help you explore why that happened. I’d suggest creating a new thread though with those screenshots 
1 Like
Please ask them explicitly to waive the overages cost for this month. They will ask for your confirmation and will mention that they will do it for you only this time, and once you confirm they will get back to you by email confirming that they will waive it for you.
1 Like
Will do, still waiting for them to respond to me, hopefully by tomorrow. Thanks for your advice, appreciate it.
shared internally with the team for awareness. Thanks for posting!
1 Like
Database triggers completely ignore privacy rules, meaning that they search your entire database (with respect to the specific Thing) every single time they run.
For this reason and others, I don’t like database triggers, I like handling stuff at the point of transaction. I don’t understand why you aren’t doing the find&replace operation immediately upon import and waiting for a database trigger, this doesn’t make sense to me.
You said the data is coming in through an API call, so this is absolutely not true. Do the find&replace in your original “Create changes to a thing” or “Make changes to a thing.”
2 Likes
I thought the database trigger was immediately on import, cause the only time the database trigger happens is when data is imported, as nothing else would happen with the database (no editing or deleting of data).
As seen in the first screenshot, as soon as the data is imported, the trigger only when condition occurs and the find and replace is the first thing it does when sorting that imported data:
Unless you are referring to another method, which I would love to hear, this is what I was going for:
I don’t understand why you aren’t doing the find&replace operation immediately upon import and waiting for a database trigger, this doesn’t make sense to me.
Hi for context,
My routelink data has a field called “OPRID”, in specific searching for values that contain “Spin #” where # is a number between 0 to 9.
Would this be a more scalable approach? As before I had no search constraints but rather let the find and replace do the searching.
Edit: Furthermore, is it possible to search via the creation date to only apply to new data? E.g. New data comes in and the trigger requirements are met, so as a constraint can use creation date = current date and time + minutes -1?
I did this once to $1,000 of overages. I begged the support folks to help me out as a multi-year customer making a mistake and they waived the entire bill!
3 Likes
I am hoping for the same as well, waiting for their team to get back to me and will update you on how it goes! Thanks for the advice 
you are using a change a list of things here when you should just use “change thing”
the data trigger is triggered for each thing that is imported
so if you use change list of things then you are changing everything that is imported up to the record that triggered the data trigger… and you do this every time a new record is imported.
in the data trigger event you can just use “change thing” with the reference “current thing”
Here are the options I have, would you do routelink now? I feel that changes the whole database still. I am not sure how to go about isolating the new data coming in and making changes to them, this is the core issue I have with this post.
Edit: As from a previous reply, would this be a good way to isolate the new data coming in?
Furthermore, is it possible to search via the creation date to only apply to new data? E.g. New data comes in and the trigger requirements are met, so as a constraint can use creation date = current date and time + minutes -1?
routelink now = new version of the current routelink (1 routelink that had it’s data changed)
routelink before = old version of 1 routelink
to isolate new data you’d likely use something like routelink before FIELD is not routelink now FIELD
if you only need to run the logic 1 time when routelink is created then use
routelink before is empty
this condition only evaluates yes if the routelink was created, since before creation it doesn’t exist
1 Like
Will give this a go once overages are sorted. Currently can’t do anything without incurring more costs for it unfortunately. Thanks for the advice!