Generous Work
  • Home
  • Blog
  • Contact
  • 0
  • 0
press Enter to search Showing all results: No products found.

    What software should I use to build an online property development database?

    By Rich Peterson on May 14, 2018

    Further details of question

    We currently manage a large database of property developments in an excel file, but we need to migrate this to a bespoke database, which will give us more flexibility to build our business processes around the data, and to add more columns and related items, such as photos, files, notes, version history, edit user permissions, etc.

    We currently manage our data in excel, and then export a small subset of that data to a wordpress front end. We would like to create a hosted database, which initially we use to manage the data and export manually to our wordpress front end, and have the flexibility to eventually link the two so they can sync directly.

    Our existing database is in an excel file and has about 900 items each with around 35 columns of data. Some of these columns need to become a separate table of linked items, for example, the list of developers of each of the properties. We need flexibility to add new data columns ourselves, and an easy way to import and export data from our excel/csv files.

    We would like to build this using a system or platform which will allow us to build up from this data, in terms of adding workflow process, user editing rights, and which we could perhaps eventually link to our wordpress front end via an API or similar, to allow direct syncing.

    We have had various suggestions, including, Laravel, google doc, but we would like to put this job out and here from experts with suitable experience, with an outline of their intended solution. We have not found wordpress to be suitable for developing the database, as it tends to be difficult to edit and manipulate the data in volume.

    Note that this project does not require a public facing front end, this is purely a solution for us to manage our data.

     


    Answer

    Initially, I’d thought that using hosted database software like Airtable or Coda would have been the best solution but the additional need for database workflow automation, user editing rights and direct syncing to a WordPress front-end means that you might find it more beneficial to use another solution. I’d recommend that you check out Airtable and Coda (you could even use Notion) but also check out the option of using Podio with the add-on of a front-end user portal software. Using this setup, you’ll be able to import your property database as a csv file into a custom app then create workflows based on the options selected. You can then set up your portal to display the information you want on a subdomain of your current website. This portal will be accessible to logged-in users and even has the option for users to be able to update the property information in the database from their portal.

    airtablecodanotionpodiowauportal
    Posted in 🌅 Now.
    Share

    Search Blog

    About

    For the past 10 years, we’ve worked with hundreds of clients and tens of thousands of students to help them get a clear picture of how to systemise their business. We’re not fans of spam, cheap mass-marketing tactics or automating your business to within an inch of it’s life. We are fans of a customer experience where humans deal with humans, skills are appreciated, personality is maintained and where clients get more value than they expected. We’re also fans of automating any process that doesn’t deliver client-facing value in a simple, easy-to-maintain way.

    In a nutshell, we provide advice, implementation support & training to small to medium, service-based businesses to help them deliver a better customer experience & a more automated workflow. Everyone on the same page, moving in the same direction with a clear picture of who does what.

    Want a streamlined business?

    Subscribe to get our latest advice, courses and project updates in your inbox.

    PreviousHow do I customise my Weebly theme?
    NextHow do I create a membership-based website with online quiz content?

    Related Posts

    • December 3, 2016

      Services for Real Estate Agents

      📚 ContentsBuild ItBoost ItBroadcast it Build It In this stage we develop the core of your online platform: A professional website for your real estate agency business A professional profile on relevant social networks Core outlets for spreading engaging content Optional customised CRM to suit your business Optional email help desk to boost customer satisfaction …

    • July 17, 2018

      Business Assets

      From the book, 24 Assets by Daniel Priestley Broadly speaking, people want to buy companies that have a good mixture of assets in seven categories: 📚 ContentsIntellectual propertyBrand assetsMarket assetsProduct assetsSystems assetsCulture assetsFunding assets Intellectual property The business lays claim to, or is known for, valuable ideas, methods or defensible intellectual property rights. Brand assets …

    • September 6, 2017

      Sync form data without using Zapier (or an API)

      We were looking for a simple way to sync data from a Typeform to our client’s CRM, Podio. To do this, we had the form data sent using the Sender Notification feature. We were able to bring across three fields of data using the Subject, Body and Attachment. For more details on emailing data from …

    • July 25, 2018

      Thank you, your submission has been received

      This is the default text shown when someone completes a standard, partially-configured website form. To change it means you have to click through a few tabs and find what text to update. Does it ever matter that someone sees this? Consider the customer journey from when they read some of your social media posts then …

    • 🏠 Home
    • 📱Contact
    • © 2021 Website: design, hosting, theme.
    • Home
    • Blog
    • Contact
    • Wishlist 0