Creating automated listicles

Need help Database
1

Here is what I want to do: Create pages automatically from the database that show lists based on certain filters.

Specifically, I have a database of companies and would now like to create pages like “43 SaaS Companies in New York” and so on.

My database at the moment has the data type “company” with fields such as name, industry, country etc.

However, I cannot figure out how to do it. I have created pages for the companies themselves, but I don’t understand how to group them into lists (at least not manually).

Any idea how I can make that happen?

Thank you so much!

2

basically you want to create a list of companies based on filter conditions.
AND
Show this list on a page?
If this is what you want to do create an Option set example “company Type” And Create a field on “company data” type like Company type accepting option set as values. Now whenever you create a company fill this field accordingly.

Now create a new page a put a repeating group element with datatype “Company” and in the data source Do a search for “company” with constraints of company type.

In this way you can display the list
Hope this helps
If you are not sattisfied with the solution please reply me.

3

Okay, that is definitely going in the right direction. Two things:

  1. I am wondering if it’s possible to bulk upload / edit option sets. I would have to edit thousands of rows, that is not possible to do manually.

  2. How do I create the pages automatically? I want to have pages for the US, UK, France, Canada, etc. etc. - is there a way to do this?

Thanks for your help! :slight_smile:

4

Screenshot (160)
Screenshot (160)1920×1080 284 KB
after creating the option sets you can bulk edit your records in this section
Screenshot (161)
Screenshot (161)1920×1080 189 KB

see my mouse cursor

5

You can’t create pages automatically. However, you can create a page that uses URL parameters to specify the list e.g yourdomain.com/view?minDate=[date]&maxDate=[date]&name=[name]

Then, display the repeating group on the page. Do a search for companies with constraints - I’m just using arbitrary filters right now.

dateCreated >= Get data (minDate) from URL
dateCreated < Get data (maxDate) from URL
name contains keywords Get data (name) from URL

Check ignore empty constraints. This will use data from the URL parameters to filter the RG.

6

Thanks! I am wondering if this solves my problem, though.

First of all, you are right, I don’t want to automatically create pages. I want to create one page that then displays different content that can be found by Google.

Here is what I want to do:

  1. Create a page like domain.com/countries
  2. Have it display the data of different companies in a country, so domain.com/countries/canada
    → the /canada page would then show all companies based in Canada.

Problem: I don’t have the data type “country”, it’s just the data type “company” with the field “country”.

I don’t know if your URL parameter solution would actually achieve this, because I want it to be saved in the sitemap and shown on Google. :slight_smile:

Let me know what you think :slight_smile: