Problem with updating customer credit after multiple purchases on Make.com

Hello everyone,

I’m encountering an issue with my scenario on Make.com, and I need your advice.

Context: I have a scenario where I retrieve the initial credit of a client from a Google Sheets document (let’s say 18.5 euros). The client makes several purchases: the first product costs 10.5 euros, and the second one costs 8 euros. My goal is to update the remaining credit of the client in Google Sheets after each purchase. Ideally, the final credit should be 0 euros (18.5 - 10.5 = 8; then 8 - 8 = 0).

Problem: The issue I’m facing is that in my current scenario, the client’s credit isn’t being updated correctly after each purchase. Instead of subtracting the second product’s price from the updated credit, the scenario always subtracts each price from the initial credit. This results in the following:

• After the first purchase: 18.5 - 10.5 = 8 euros (so far, so good).
• After the second purchase: instead of 8 - 8 = 0, the scenario performs 18.5 - 8 = 10.5 euros.

In other words, the initial credit (18.5 euros) is used for each subtraction, rather than updating the remaining credit after each purchase.

Hi @MVIIX.C

Ensure that you update the credit (D) column of that row with the calculated amount. Otherwise, the credit amount (18.5) will be used for all subsequent calculations. You can directly use this calculations in the update module.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

1 Like