Like a Classifieds page

Ask the community
,
1

I have been trying to get my public data sheet that is user submited, to work like a free Advertisement page for products. its not quite panning out . in my case the user is supposed to submit a title, description, link, and photo, for the public data sheet to display to all site visitors.

- Problem one,
the “gallery” doesn’t have enough display power for more than Title and Description link, i need it to link, to say, a “more details” page.

- Problem two,
in the case just a title, description and link were sufficient. the “links to” option doesn’t work.
when i link the “links to” section up to a user submitted url. it doesn’t work , data does not show. and it defaults back to basic gallery, with a few errors.

so in conclusion:
i guess i’m asking if i can get the “data sheet” function to work like, well , a simplified version of Craigslist. is this going to be an option soon. i see here that it may be…

uval says:
“Yep, we’re working on it.”
See https://www.wix.com/code/home/coming-soon

so, 1) When
and
and, 2) my site really revolves around a feature like this , is there any alternative till this update comes out? right now this is what im working with https://www.wittysprout.com/forum/giveaways
and it sort of works but looks very unprofessional (like my whole site XD)
im very tight on money right now and i cant afford an option like Caspio.

  • Regards
    Francisco
2

Hey

  1. Create a collection to hold your giveaway register and make a submit form where people can enter information that is submitted to that collection.

  2. Create a custom page from that collection by right clicking the collection, this would be your details page for every record.

Straight forward but might demand some coding from you to make it really good.

But then on your site you use the forum app, is that good enough use it.

3

yes that’s the idea , but unfortunately the only thing i think i’m able to link to the datasheet is a gallery id rather it a list. and yes the gallery works but i want my site visitors to be able to click on the product in the gallery and either be sent to the product sale page (external site) OR be sent to a more details page, i don’t want to have to manually make a new page every time a user submit a product. that would be a little taxing.

4

Yep, we’re working on it. That’s all the info I can give at this time, sorry.

Here’s a workaround which I like to call “fake repeaters” or “fakepeaters” for short. It’s far from ideal but it does the job if you’re not afraid of wading into JavaScript Land.

Here’s an example of what can be done. Check it out live:
https://uvalbwix.wixsite.com/fakepeater4

1212×487 277 KB

And here’s a sample of what the code might look like (some of this is specific to my example, you would need to modify it).

import wixData from "wix-data";
var allApartments = null;
var currentItem = 0;
const numItemsInFakepeater = 3;

$w.onReady(function () {
	getAllApartmentsFromDB();
});

function getAllApartmentsFromDB(){
	//Get all the records from the collection called "Apartments"
	wixData.query("Apartments").find().then(function(res){
		allApartments = res.items;
		//show the first batch of apartments
		showApartments(0);	
	}).catch(function(err){
		//in case of an error
		console.log('Error fetching data: ' + err);
	});
	
}

function showApartments(startIndex){
	//Loop through and draw the next n items
	for(let i = 0; i < numItemsInFakepeater; i++){
		//check if we're at the end of the list
		if(startIndex + i >= allApartments.length){
			//hide the whole apartment container for the corresponding item, since there's nothing to show
			$w('#containerApt' + i).hide();
		}
		else{
			//Otherwise, draw the current one
			
			//Get the current one from the data we fetched
			let currApartmentData = allApartments[startIndex + i];

			//Set the elements in my fakepeater accordingly
			$w('#imageApt' + i).src = currApartmentData.picture;
			$w('#priceApt' + i).text = '$' + currApartmentData.priceUsd;
			$w('#titleApt' + i).text = currApartmentData.title;
			$w('#descApt' + i).text = currApartmentData.description;
			$w('#readMoreApt' + i).link = currApartmentData["link-Apartment-title"];
			$w('#containerApt' + i).show();
		}
	}
	
	//update Next and Prev buttons
	if(startIndex===0){
		$w('#prevButton').disable();
	}
	else{
		$w('#prevButton').enable();	
	}
	if(startIndex+numItemsInFakepeater >= allApartments.length){
		$w('#nextButton').disable();
	}
	else{
		$w('#nextButton').enable();	
	}
}

export function prevButton_click() {
	currentItem -= numItemsInFakepeater;
	showApartments(currentItem);
}

export function nextButton_click() {
	currentItem += numItemsInFakepeater;
	showApartments(currentItem);
}
5

Thanks , i ended up doing this https://www.wittysprout.com/giveaway-list , it worlds quite well.

6

I see this is about a year old so see if anyone finds this, but I too am trying to build a classified section for a Wix website and it’s making me want to pull my hair out. Extremely frustrating. Uval’s solution appears as if it’d get the job done, but I it’s a little gray after copying and pasting the code into the developer section what a person would exactly have to edit or how? I have a basic database set up (Title, Description, Price, Date Submitted, and would like to allow multiple images, so I have image fields (Image 1, Image 2, Image 3). I’ve been looking at accomplishing this with a list (and this works decent except the ability to have a (Read More) button to view additional information and or pictures) - I’ve looked at using a Gallery, but none of it seems easy to implement. If anyone sees this, much help would be appreciated! I’m willing to give login info and even pay someone to do a basic/initial set up that I could maintain etc. - thanks!