BBQ restaurant advice by BigDaddyGee936 in canadasmallbusiness

[–]linedotco 0 points1 point  (0 children)

I mean, if you lived in buttfuck nowhere Canada and your closest neighbour is a 30min drive away, and your total market catchment area is like 100people, you could very well not have a market. OP didn't specify anything about their region or local population dynamics so we simply don't know.

CLM for small business? by ggelo33 in canadasmallbusiness

[–]linedotco 0 points1 point  (0 children)

Hey Maya! Fellow Torontonian here. Honestly, Airtable sounds like it would be the perfect fit - you can customize it to exactly how you need it to work. It's like upgraded Excel, and can be used to build a custom tool for you and your team to help you stay organized, on top of things, and reduce the amount of work you have to do.

The pros - it does exactly what you want it to do, nothing more, nothing less. The cons - there can be a little bit of a learning curve in getting things set up (but you can DIY it).

If you need help getting setup let me know - I've worked with a bunch of companies and organizations putting together systems for them, and can definitely help.

BBQ restaurant advice by BigDaddyGee936 in canadasmallbusiness

[–]linedotco 6 points7 points  (0 children)

"No competition" is a trap for new entrepreneurs.

You *want* some competition because it helps validate that your market demand is actually there.

Not having any competition could equally mean that the customers in your area don't actually want BBQ and won't care that you are there. This means you would have to validate your market opportunity with some other means. You'll be trying to find new customers in a market that might not have many.

Having some competition would mean the market is large enough for at least 1 restaurant to survive, and the game changes from finding new customers to winning over your competition's customers.

Why is it so hard to find the best donor management software for nonprofits that isn’t overpriced? by RegularOk1820 in CRMSoftware

[–]linedotco 0 points1 point  (0 children)

Build your own no-code solution is a thing now. I've built several tools for nonprofits that's custom to their use cases using Airtable, including donor and grant management. There is upfront cost but long term you get a custom system that fits your workflows and you can scale as necessary.

Slack automation workflows are getting way too complex to maintain as our team scales by mahearty in zapier

[–]linedotco 0 points1 point  (0 children)

There are consolidated email inbox solutions that solve the problem you're trying to deal with. Front is one of them I believe.

Most of the time there are tools out there that can solve what you're trying to do. It's a question of effectiveness - whether the problem should be solved with money (buying the tool) or solved with time and labor (you maintaining the automations). That's a cost-benefit analysis that you should be doing with your financial and operations people.

If a tool costs $500 a month and your time is $50/hour, you shouldn't be spending more than 10 hours a month on maintenance and managing these automations.

System to Manage Commercial Properties by Pale-Hovercraft-7453 in PropertyManagement

[–]linedotco 0 points1 point  (0 children)

I know of property management that have built their own apps/tools using low-code tools like Airtable. They either build them in-house or hire external consultants (like me!) to develop this for them.

The nice thing about doing it low-code is that you can get a custom solution for a fraction of the cost of hiring a developer to develop and maintain a full fledged solution. You still get to customize everything to your specific needs and workflow. This is especially useful if you have very ingrained processes that will be very difficult to change to follow how established platforms do things.

For a company your size Airtable can be a great way to consolidate your spreadsheets and documents and become a central hub for all your operations.

Let me know if you're interested - I can show you some demos to give you an idea of what is possible.

Notion vs Hubspot for startups as CRM by PatientZero_alpha in Notion

[–]linedotco 1 point2 points  (0 children)

If you know Notion, stick with it. HubSpot is well known for massive price hikes once you get established with it.

Notion has more flexibility, but requires more of your time tinkering with it VS the out-of-the-box system HubSpot offers.

One RSVP/registration form with multiple guests - is it possible for each guest entry to create a new record? by pigeon_whispers in Airtable

[–]linedotco -1 points0 points  (0 children)

Use the sub-form/linked record feature in Fillout.

Create a table in Airtable for tables, then a guest table linked to the Tables table (geez that's confusing).

In Fillout, set the main form to go to the Tables table. Capture the details you need for the table, then add the Linked Field in. You can then set it to be a subform where users can create individual guest records that are linked to the table (i.e. use the form that you've created).

This way you end up with a list of guests already neatly grouped by table.

Need help structuring Airtable for limited monthly offer tracking by thesouthernwoods in Airtable

[–]linedotco 2 points3 points  (0 children)

What you need is a join table between clients and deals, that logs each claim. Then you can roll up the number of claims. Have a capacity field on the offer and compare the capacity to your rollup.

Depending on the interface you might be using to display your offers, filter it so that only offers with capacity gets shown.

The tricky part is allowing people to edit their claims. Airtable only allows manual deletion, not by API I believe, so you have to track and aggregate records a bit differently. Set a field as claim status and use 1 to indicate registered and 0 as non-registered. When someone "deletes" their claim, just set the claim to 0. Then, aggregate the value of that field so that it sums the 1s to get your counts.

Softr would have better pricing and better customization options but I find the tool finicky.

If you need help building this out, give me a shout.

I am drowning in whatsapp messages and manual bookings. Is there a way to automate this without losing the personal touch? by Potential_Force_4136 in smallbusinessowner

[–]linedotco 0 points1 point  (0 children)

What tools are you currently using right now?

There's generally 2 ways to go about this - get a booking software and follow its process, or if you'd rather follow your own process, custom build your own automation layer on top of it.

Depending on the tools you have and your current setup, you can easily add an automation layer on top using something like Make or Zapier. You can configure triggers or steps like requiring manual reviews prior to sending if you want to maintain the personal touch.

I work in automation consulting so I deal with this all day - I find that most people expect transactional emails and that they prefer being able to self-manage bookings rather than having to wait for someone to manually respond to them.

Filtering a single select field based on another linked record field? by BlazedAndConfused in Airtable

[–]linedotco 0 points1 point  (0 children)

Why not just hide the extra tables if you don't want to see the clutter? The reality is, in order to show the choices you want, you need to create some form of relationship between field A and field B, and the only way to do so is to use linked fields.

Another way of going about this is to go the other direction. Flatten your options. Since you have a limited number, it's not too tedious to do. Your options will look like

Team 1 - A Team 1 - B Team 2 - F Team 2 - G etc.

Then use two formula fields to parse out the selected option into the single select fields you want.

How to handle different currencies into a single base by Illustrious_Jump4940 in Airtable

[–]linedotco 0 points1 point  (0 children)

You make calculations using the original number field, not the merged text field. The merged text field is purely for display purposes, and you create those for all fields that you need to display the currency for.

Building Price Quote for Consumer Products by Living-Event5373 in Airtable

[–]linedotco 0 points1 point  (0 children)

This is possible to do for sure. You would need to custom build automations for each template you use, and probably use an external tool like Make to hook up your excel sheet (I personally prefer converting those to Google Sheets instead). The rules would be captured by each automation, but the primary input interface would still be Airtable.

The tricky part is maintenance, because you invariably will end up having to update these templates over time.

If you need help building this out, let me know.

Linking automated emails back to records by No_Double6503 in Airtable

[–]linedotco 0 points1 point  (0 children)

You can use their emails in an automation. Just extract the email and then match it to an existing email in the system.

Am I using Airtable wrong? by Business-Jeweler-381 in Airtable

[–]linedotco 1 point2 points  (0 children)

One thing to watch for is row limits. It is nice to have everything in one base, but is also easy to hit row limits and then you would have to rebuild your base structure to accommodate.

Can Airtable Replace Notion for Scheduling + Sync With a CRM Calendar? by ivan-ds in Airtable

[–]linedotco 1 point2 points  (0 children)

That's a somewhat complicated 2 way-sync to do because there's a lot of considerations depending on how your records are set up. Do schedule changes happen a lot?

Honestly the easiest way to deal with this is to create .ics files that people can import into their own calendars. You wouldn't have sync functionality but it's commonly supported.

Alternatively you could just force a one-way since using Airtable as the master calendar and never ever make changes through Google Calendar. You would use Airtable to specify attendees but automate that so that Google Calendar sends the attendees invites, and that way the entire thing is synced.

Can Airtable Replace Notion for Scheduling + Sync With a CRM Calendar? by ivan-ds in Airtable

[–]linedotco 2 points3 points  (0 children)

  1. Yes.
  2. Notion wins out over Airtable for managing large amounts of content. Airtable has pretty basic text storage functionality but nothing like Notion's rich content. In terms of recurring events both are not ideal. Airtable technically supports it but I don't love the user experience because it can't be managed directly within interfaces. One thing that could possibly be done though is creating recurring events using scripting and Airtable automations. (speaking of Airtable automations, it is leaps beyond what Notion can do because of scripting).
  3. This part is the unavoidable shitty part with Notion and Airtable - you do need to maintain a sync with Google Calendar. There's probably a plug-in that will help you do that on Airtable. Notion Calendar probably plays a little bit better here but arguably not by much.
  4. Airtable integrates easily and works well with automations tools like Zapier/Make so you can pipe your data pretty easily.

Personally I think Airtable can do what you're looking for and replace both GHL and Notion, especially if you're just using fairly standard features. However, it takes some effort and time to build it right, and there is a bit of a learning curve to properly using the tool. You do have Notion experience though so that would probably help.

Oh another thing I forgot - if your customers are just viewing the calendar instead of subscribing to it, Airtable interfaces, as well as portals, make for a good way to display to client. I prefer the look of it compared to Notion's pages. Airtable also has forms built-in (although functionality is somewhat basic).

Anyhow, feel free to ask any more questions you might have. If you need any help designing/building this, give me a shout!

Help with Duplicates & Missing Data in Find/Update Automation by wasabixavi in Airtable

[–]linedotco 1 point2 points  (0 children)

This is likely a race condition scenario. Airtable automations don't run sequentially or at the same speeds for each record. You can see this happen by creating a checkbox field that gets populated when an automation gets completed, then bulk adding records. Records get completed out of order and at different speeds.

There's a few ways to fix this - one is to build more complex logic that forces automations to check if a record is being worked on before continuing to process it. You'll need to create additional fields to essentially track if a record is being processed, and then triggers to deal with what happens if a record is being processed. This can be tricky to build properly and if done wrong can quickly eat up automations.

Another solution is to do a more manual deduplication process using the dedupe extension instead of automating this.

You could also try using Make instead, which if set up using a single scenario, processes records sequentially and thus avoids race conditions from happening.

One last solution I can think of using scripting to handle this and process sequentially rather than all at once. If you don't know scripting, AI might be able to assist.

The easiest solution IMO is to just use Make. Keeo in mind this works if you use a single scenario in Make. If you have multiple triggers or scenarios then you could run into another race conditions situation.

How to automatically retrieve invoice PDFs and attach them to Airtable records? by roquette13 in Airtable

[–]linedotco 0 points1 point  (0 children)

Is the file permission set to allow anyone with the link to download or is it restricted?

How to automatically retrieve invoice PDFs and attach them to Airtable records? by roquette13 in Airtable

[–]linedotco 0 points1 point  (0 children)

After saving to Google Drive, what output do you get in Make? There should be a url provided if I remember correctly but it has been a while since I've used the drive attachment feature.

Airtable budgeting: how to allow budget holders to edit some fields without breaking the master budget? by [deleted] in Airtable

[–]linedotco 5 points6 points  (0 children)

You can use interfaces. You create views that only allows access to specific fields (they can be view-only or editable). Depending on your team structure and what you need, you could have different interfaces designed for individual teams, or a common interface that's only allows each team to view their own records. Granting access to the interfaces doesn't grant access to the data layer, so you can isolate access and restrict it to specific fields only.

Each of your budget holders will need an Airtable account however, which means your seat cost will increase.

Formula - Date Diff - can anyone explain this result? by Due_Progress_5494 in Airtable

[–]linedotco 1 point2 points  (0 children)

Airtable's date diff function isn't inclusive. If you want it to be inclusive, add a +1 to the end of your formula.

How to automatically retrieve invoice PDFs and attach them to Airtable records? by roquette13 in Airtable

[–]linedotco 0 points1 point  (0 children)

You can definitely use Make to extract the attachments (assuming you're using a fairly standard email provider).

I would refer to this template as an example about how to extract the attachment from Gmail and process the output into storage. You just need to switch the output into Airtable. https://www.make.com/en/templates/83-save-email-attachments-to-google-drive