Can we make a provision where the client can pay money by credit card?
You can connect the app and the payment, but you need to do it in the backend through the API.
@Aleksi_Alkio If we do this, do we end up with a data protection issues since Google Sheets will store all CC info in the version history?
Or can you clear the version history?
When you connect the payment gateway with the spreadsheet, the CC data is not in a speadsheet. The payment platform will handle all CC data.
But assuming the user enters the CC details into appsheet, the data path would be Appsheet => Google Sheets => API => Payment Gateway.
My concern is that because the CC details are written is Sheets, there is no way to permanently delete them.
Because of the version history
An advice… don’t try to use CC data in any way in the app… ever.