Setup

Phase 1 Setup #5: Adding Custom Tables

Step by step process:

  1. Within a client profile you can see something called tables which you can create for yourself if you would like to measure data in different ways for specific clients.
  2. In this case, I’m going to create a typical table and I navigate to custom tables. here I can create a table, add a custom table.
  3. In this instance I’m going to call it Orders to track the orders that are coming through.
  4. I’ve now created the table and I can click and edit.
  5. Here I can add various different columns that I might need.
  6. For the first one I want to add a date column and it’s going to be called Orderdate.
  7. The next column that I would like to add is Items ordered.
  8. This one will be a single choice.
  9. In this demonstration, I’m going to add Tinker Dust and empty Hook spray.
  10. i’m going to call this Items ordered.
  11. Add a column.
  12. Next, I’m going to choose status which is single choice and I’m going to have three different statuses called new, pending and complete.
  13. And the last field that I would like is perhaps a button so that if I press it, I will notify the client via e-mail about the progress of their order.
  14. So I’m going to add and look for button.
  15. This one is going to be notify client and I’m going to choose a green button color.
  16. After I added my custom table, I can go to the clients, go into a client profile.
  17. Here I can see the tables option and my orders table.
  18. I can double click here to rename it to orders if I would like.
  19. Here I can choose create and choose an order date.
  20. Then I will choose items ordered and I’m going to select the status as new. I’m also going to add another one with a different date and the items ordered will be antihook spray and the status is complete.
  21. So this is how you can add a table displaying any information that you would like to see and you can add some additional functions.
  22. In this instance you could click Notify Client, where you can set up automation to automatically notify the client about their order.
  23. Tables can be used in a variety of different ways.
  24. Imagine an Excel spreadsheet that you have inside your CRM for a specific client, measuring anything that you would like to track.
  25. You can also have multiple tables added within this tab, for example an orders table, and another table below that, and another table below that, all measuring different things for this client.

Find any row by its ID or text

Every row in a custom table has its own ID. Type in the Search rows or IDs box to find rows by ID or by any text they hold, such as an order number or a product name. To pull up several rows at once, paste their IDs with commas between them, like 586029, 581889, and BaseCloud shows up to 500 rows together.

Search also finds rows by a user named in a user column, so typing a colleague’s name shows every order assigned to them. The same search works in the client’s table panel and in report cards that list table rows, in both their table and Kanban views. A report card’s CSV export includes each row’s ID, so your spreadsheet matches the CRM line for line.

Setup

More in this section

Phase 1 Setup #4: Bulk Imports

Step by step process 1. Once you have added all of your custom fields and you’re happy with how your database is going…

Run your whole business from one client record

Calls, texts, WhatsApp, email, quotes and automation in one CRM. Live in 48 hours, with your data migrated and your team trained.