There is no "GET" in database button options?

Discussion Ask a question
,
1

I have a database of collector cars owned by a specific member. Each car has a unique ID called the dash_number. I have created a database form where the member/owner CREATES a database entry of the car he owns. What I am looking for is how to allow that member to retrieve JUST HIS ENTRY in order to update it? I created a second database form with just owner email and the dash_number connected to the database and a submit button.
After connecting the button to the dataset and scrolling to bottom “link connects to” all I see is:
Load More
Next Page
Next Item
Previous Page
Previous Item

My thinking was to use this front end as the query to get the correct database entry onto the original form for update. How do I do this?

Should I use a copy of the Original Input Form instead and add an additonal button for “GET” to retrieve the items and then have another button for “Save Changes”? And if so, would they fill in the email and dash_no and click on Get? This is how it is currently being done with an Informix database backend on the old website.

Thanks
JD

2

While searching for a solution I found in Wix_data API:

But again this is unclear to me. I assume I could somehow replace the “00001” string with the value of dash_number as typed into the form? Also, in the example given, the results seem to be all COMMENTS?

import wixData from ‘wix-data’;

// …

wixData.get(“myCollection”, “00001”)
.then( (results) => {
let item = results; //see item below
} )
.catch( (err) => {
let errorMsg = err;
} );

/* item is:
*

  • {
  • “_id”: “00001”,
  • “_owner”: “ffdkj9c2-df8g-f9ke-lk98-4kjhfr89keedb”,
  • “_createdDate”: “2017-05-24T12:33:18.938Z”,
  • “_updatedDate”: “2017-05-24T12:33:18.938Z”,
  • “title”: “Mr.”,
  • “first_name”: “John”,
  • “last_name”: “Doe”
  • }
    */
3

Hi,
Can you please share a link to your site and specify the name of the page so we can inspect?
Roi.