Track SMS usage

How To
1

I have a scenario that when a new row in table 1 is made, it triggers an SMS.
Table 1 has the Client that this SMS was sent from.

Each time this happens I want to record that this client has sent another SMS, so I can track client SMS usage and oncharge them on my own.

I seem to be having issues making this work.

Using google sheets

Something like add 1 to column “usage” on row where “client” is “client” from table 1 row that triggered SMS

2

Welcome to the Make community!

You might not even need to “record” anything, since you already have the records in rows.

All you need to do, is at the time where you want to calculate the usage, you simply perform a Search Rows for the Client in the Google Sheets.

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!

1 Like