inserting info to database issue.

Ask the community
, ,
1

Hi, i have wix store in my website and i made a button in product page that when user click it, it insert the user’s id and the productid into database named :“Purchases”.

Now i made it successfully and it does really insert it.
My question is : i created purchases database with columns : ProductID , CustomerID.

!3381x1843
!3381x18433381×1843 97.9 KB

this is the insert code:

!663x933
!663x933663×933 117 KB

but when it insert to the database, Which i check from the dashboard, it inserts it to new columns which is : {ProductID} and {CustomerID}
This is what i mean:

!3105x1657
!3105x16573105×1657 374 KB

the ProductID is empty, it inserts it to new column {ProductID}.

i might be doing something wrong because im not pointing to the existing productid and customerid columns, im pointing to a new columns instead.

so how would i change it ?

Regards

2

Will anyone help me please?!

3

you need to use the correct field key in your code. I can tell you are using the incorrect field key due to the fact field keys always start with a lower case character.

Click on the column in your collection to get the correct field key then copy it into your code