Programmer to help get data to and from AirTable, Webflow CMS or Google Sheets

Hi there,
What kind of data is your client trying to collect. Depending on the type and country(ies) of roll out…there are legal and security impacts regarding how that data is managed. There are many approaches which one applies to this client is the real question.

As an example…if my client was a little league baseball team and I was managing a roster of first names, player number’s and stats and the rollout was for any US state, then the data would fall under the rules of CCPA and there are certain rules and regulations regarding the storage and handling of that data. If I left out the player’s first name… then I would not have anything to worry about. You could use any method and the data could be exposed for that matter.

However if your client was a pharmaceutical with patient information that has patients in the US and outside the US you would fall under CCPA, HIPAA and GDPR. A completely different solution requiring never showing anyone how the system works.

What do you have?

ok…so is the address that of your customer or that of the user of the site? If it’s the customer then you don’t have anything to worry about…if it’s the user’s address, you have to follow applicable laws to secure, encrypt and make sure the data is deletable upon request.

So let’s say I have a product configurator for a bookshelf. I get to pick the wood, the measurements, and the finishes. Once the product is configured the “configuration data” can be shared with the main website in a number of ways but because you are storing it with a user ID the website must have the ability to delete this information upon request of the user.

You can store data and configurations in Verge using a dictionary, a list, or create an array using JavaScript. Once you have it stored in the right format you can then send it to the database. You can assign the necessary function to either buttons on the parent window or assign them to buttons you creat in verge.

Luckily, unless you are building the entire website, ordering system and everything else, your customer probably already has a database associated with their website, such as SQL, Oracle..etc. They will probably even have a cookie policy you will want to become familiar with.

You will need your customer’s IT team/person to create a table within their database and give you access. You could then push your data to the table, in the same manner, you submit data via a secure web form You could use JavaScript, PHP, etc. There are other ways as well…this is just a simplified example. Usually, the company’s IT department will dictate the method based on their internal security requirements and give you access to an API or other method they prefer.

If your client is a small company that doesn’t have an IT team that doesn’t have a database you have a big choice to make. Is the profit from the job sufficiently large? Will your insurance cover you in the event of data/security breach? Will you be responsible for updates and maintenance to ensure continued security during its use? Will the client give you a full liability waiver? How will security testing be performed to ensure what you built is of “professional standard” should you ever go to court? These questions always have me passing on small clients when it comes to database work but everyone has their own level of risk and reward acceptance.

Because there are so many permutations and so many solutions I cant give you a more specific answer. Once you have selected or been told what database you are going to use and how you are going to store that data in Verge…I will help you with a plan to move to the DB securely.

Hi there,

John sent over the quote. I was just thinking you do have another approach that you might want to try. Since Verge3D has a plugin for WordPress you could use that too. All the information is online: https://www.soft8soft.com/docs/manual/en/introduction/Wordpress-Plugin.html#Uploading_Applications