Stacker Customers

<@U03QRR8AXT2> do your Google Sheets and Airtable base have any other field or piece of data in common?

yes. There are common fields around project name, project code etc. Airtable (and therefore Stacker) has the associated google sheet link as a record too.

I have various automations with make that copies data form the google sheets into airtable

You should be able to craft and output the Stacker URL of a record using a Stacker formula.

Something like this:
```CONCAT("<https://workspacename.stackerhq.com/appname/tablename/view/>", RECORD_ID())```
This will craft the link to that record. In my case,
```CONCAT("<https://meerkatsinc.stackerhq.com/meerkat/evaluation/view/>", RECORD_ID())```
outputs
```<https://meerkatsinc.stackerhq.com/meerkat/evaluation/view/opp_rechvuVsOZq3fz6O4>```

<@U03QRR8AXT2> What I would also suggest considering is that you create a Stacker Automatic link based on the Project name. This will create a automatic linked record field if the project name matches. With that you would automatically gain the link for free

Here’s an example I’ve made as a test:

And here’s what it looks like in Card view. In your case, the field would be “Project” or something similar.

Sorry - one question. I've got the formula working but how do I sync it back to Airtable (as from there I can send it to google sheets using <http://make.com|make.com>)? I've syncd the schema but it's not appearing in Airtable.

Did you perhaps create a Stacker Field? If you don’t add the field to your Airtable base itself, it won’t sync to Airtable as it exists only in Stacker.

Yes I did, which I've worked out doesn't sync back to airtable. Is there a different way of using the stacker formula field that will sync back with airtable? Otherwise I'm left with being able to extract the Stacker URL but only being able to access that URL in Stacker, which defeats the purpose. Apologies if I'm asking obvious questions! Thanks.

<@U03QRR8AXT2> You can export tables and it will have all fields including Stacker in it, but it would be a manual process.

I might have misunderstood the reason _why_ you want to have this in both data sources. Does the record ID _need_ to be in Google Sheets because someone is looking directly in Google Sheets instead of the Stacker app?

Yes, I want the Stacker URL in google sheets as when someone goes direct to the google sheet to edit their time sheet I want an easy way for them to then get into Stacker. I've sorted it with a Zap though. Thanks!

Hey everyone - having some trouble using the date/time picker for users who are in different time zones.

Trying to trigger some down-funnel automations based on when an event starts. But, being able to make this happen reliably is becoming tough when the date/time picker seems to be timezone agnostic in Stacker.

Any solutions that folks have come up with? Anything I’m not seeing? Airtable as database.

Also Facebook messenger has a plugin and is free

<@U02G1V7KTB6> Chatwoot is great, and open source, free plan also up to 3 operators

<https://dna-pc.notion.site/Stacker-Chatbot-using-Chatwoot-b59f3c3fd20e4da79c52719e36bd372b>

Hey <@U0146FKFCKE>. It is not in the immediate plans, but the request is very sensible and sounds like a potentially quick one. I’ll share it with the team. :+1:

:pray: Please do, I’ve requested this multiple times over the past 2 years, it’s definitely a pain point for our users (and for our support team).

it appears it allows it for a split second and quickly strips it out

Hey <@U01B1LTTYQJ>, sorry I missed this! Here's the scoop:

• We use Quill.js under the hood. 
• Linked images can't be put into Airtable fields though, which I'm assuming is what you're using for the data source
• You _can_ add an image in the Stacker Tables rich text editor via the toolbar, but not an image that acts as a link


Thanks, Oli! It looks like linked images _can_ be put in, but they are being stripped out.  Take a look at the GIF.  Weird, huh?

I think that first part is just the browser’s handling of the operation, but I could be mistaken.

it could be though that Quill.js parses it correctly but when it updates Airtable, the response from Airtable strips it out

so it flashes until there’s an updated response from that record from Airtable? Not sure

Yeah, I could be totally wrong, as I was just going off of the GIF there. lol

Thanks for letting us know. We’re looking into it.

I think <@U0146FKFCKE> might have some experience with different validations

Indeed!
<@U03D4BP98LV> What we do is allow users to give us the phone number in a format of their choice, and then, through a 2-steps formulas, we get the phone number in the format of our choice. The formulas are quite complicated.

Thank you both!  Ambroise, if I may inquire, does your form allow only one number at a time?  (and I am not surprised at the complexity of the formulas)

Do you mean you’d like the ability to store multiple phone numbers within the same column?
If so, I’ve only done it for one phone number per column.

What’s your need for using the same input/field to store multiple phone numbers?

There were a few similar reports recently, but they turned out to be browser-related.

Do you get a different result in another browser, or in a new profile?

It works for a different workspace. I did add a new table and refresh the schema

Well, that’s something. That shouldn’t affect being able to view the table though. :thinking_face: Any luck in a different web browser?

In chrome, this workspace isn't even logging in:shrug::skin-tone-4:

Hmm. Can you send an email to <mailto:support@stackerhq.com|support@stackerhq.com> ? Probably best to exchange more details there.

<@U01QZ40HRFW> this was the same problem I have. Only for one of my apps, but all others were fine

It seems to be some stale data being cached, at least in all the cases I’ve seen so far. This should do the trick: <https://support.google.com/chrome/answer/95647>

Hi <@U03RT7UAPPU> was just able to reproduce this again. For Chrome. I made some changes to Airtable. On Stacker, went to App Settings &gt; Data Sources and clicked on refresh schema. Then clicked on Manage tables and the side panel vanishes. I had to refresh cache again to get it back.

<@U01QZ40HRFW>: What sort of change in Airtable? I’ll see if I can do the same here.

Thanks so much! I’ll see what I can find. :)

<@U01B1LTTYQJ> or <@U01QZ40HRFW>, do you still have the app in the broken state? If so, could you send me a DM so I can look into this with you?

I believe <@U01B1LTTYQJ> gave me all the information I needed, I just need to get a steady repro on my end. Will update you

I believe it has something to do with resizing the admin data grid, but I’ll let you know when I find out more

To be clear, I don’t mean that you necessarily resize the admin grid—I just believe the issue is within the resizing component.

It seems like you folks found one of the most bizarre bugs. :simple_smile: Finally have a repro: <https://www.loom.com/share/6b99bc0fb01f4010a6dcae54a48475ff>

If you’d like to avoid the issue until we fix it:
1. Clear your site data
2. Open the admin data grid
3. Resize it
You should now be invulnerable to the bug :simple_smile:

Thank you <@U02N890SW84> for the follow ups even though it was an edge case! We all definitely appreciate it.

<@U01CC92QN0Z> I have quite a lot of experience with this, you don’t necessarily need to merge your tables.

• Use different apps, one per persona (has its own pros/cons, sometimes it is the best option)
• Use a different Stacker app version (Customer List) to allow different kinds of users from different tables
I could dive into this more, but I’m full right now.
Don’t hesitate to get in touch on Slack, we could have a quick meeting.

Hi <@U01CC92QN0Z>: influencers and artists are fundamentally the same thing: people. People who can be influencer, artist or in rare cases even both. For the backend in Airtable, this is a case for a single "people" table (or "contacts") containing a "role" field which is a multi select with values {Influencer, Artist}. For the frontend in Stacker, you can then use the value in "Role" like a record type, i.e. to define which fields to make mandatory. If the workflows and things to do are very different, then 2 apps in Stacker is the best design.

That does sound like a long time - definitely reach out to support if you've not already. They should be able to diagnose things a bit easier.

Any suggestions? We have had some Airtable issues, too. But this is a Stacker thing, for sure.

Hey ... we're experiencing an issue of some added fields appearing as deleted when deleted a completely different added field.  When we delete one added field, another added field that was created is removed from view.  However, when we create a new one, the one that was removed from view is returned. --&gt;.  <https://www.loom.com/share/9918dd62bf614179b2a1db64d08ddfe5>

Question ... is there a problem with table linkage in stacker?  A clearly obvious one to many mapping isn't returning any data.

<@U01QZ40HRFW> It’s possible using custom CSS.

I haven't heard of widespread problems, and I believe you're already talking with support via the app so hopefully we can get whatever's happening resolved soon.

Yeah, but the performance has been really bad today, in particular, so I wanted to know if it could be a wider issue.

Hey Puneeth, no not at the moment :disappointed: But we know it's something interesting for people to be able to present this data in different ways, so thanks for letting us know.

I asked you a similar question on another message so sorry for the repeat - but would you mind elaborating a little on what you're trying to achieve with this?

I know that Seb and others will have more insight to offer, but just as a starting point it’s important to keep in mind that it isn’t as simple as a user count; all of the users, data connections, tables, fields, etc. that compose an app have an impact on its performance (along with client hardware and software resources, browser, extensions, network connectivity, etc.)

So there isn’t any easy answer to questions about what “Stacker” can support, since each app and its data and user base will be very different — which is also why we can’t really test for a lot of this to try to get concrete answers to these kinds of questions/concerns.

Individual Stacker apps are not only what we put into the platform, but also to a large degree what folks like you put into them (an new empty Stacker app doesn’t do much of anything). This is very different than if we made a monolithic “app” software product that was the same for all users. It’s one of Stacker’s greatest assets (which is why you’re using it) and also challenges (which is why you’re bringing this up!)

That’s not to diminish the issues you and your users have been having, but rather to kick off a discussion about the complex topic you raise. We’ll continue to work with you to do whatever we can to help. &lt;3

Yeah, I understand it can be hard to identify precisely, but rough figures would help. For instance, how many active users could be handled by a very small app? That would basically be the “cap”, as any bigger app would typically not be able to handle that many users.

And, if it’s hard to anticipate, it could be figured out from actual response times and charge issues. For instance, my app A (a really big one) could let me know than it cannot handle gracefully more than 100 users at once, while the app B (a small one) could handle up to 500 users at once. Those metrics are important for business, and they could be “derived” from how our app behaves for real.

Performance never were a key issue so far, but this page crashing is a game changer, it makes the whole app unusable. I knew perfs weren’t super great but the app was still usable. If I can’t scale with Stacker, I need to know, and fast.

Absolutely. Personally, I like the idea of Stacker having some threshold of degraded performance that results in appropriate parties being notified…but defining that is the hard part. I’ll let others chime in here.

(*The hard part from a Stacker perspective; for you, it’s knowing if taking your app “live” with an actual userbase will kill it compared to when it’s got a tiny load while being built…)

Hey <@U0146FKFCKE>, while I don’t know the specifics about the number of users being able to use the app simultaneously, crashes shouldn’t happen either way. This is not the experience we want you (or anyone else) to be having.

We could definitely do a better job at setting boundaries of what is possible and what isn’t, and I’ll make sure to share that with the team. Perhaps we could expose some basic metrics and estimates like you suggested.

All that said, we do have indications that the issue you are seeing is isolated to your specific app and are actively looking into it. I’ll follow up with you in a DM with some private details.

Same issue on my end. I'm in Canada, Quebec

Hi!  Thanks for reaching out! <@U032XT3V400> and <@U01BA5BFZAN> could you email <mailto:support@stackerhq.com|support@stackerhq.com> with the workspace URLs so we can take a closer look. Thank you!

We are looking into what is causing some admins with multiple workspaces, using the <http://stackerhq.com|stackerhq.com> sign in flow, to be asked to create a new workspace. We will keep you updated! Thank you for flagging this for us.

Hey <@U03L6UNAQQG>, thanks for reaching out, double check your permissions are enabled for this field on both tables. If this isn’t the issue, could you email us at <mailto:support@stackerhq.com|support@stackerhq.com> so we can take a look? thank you :slightly_smiling_face:

Screenshot 2023-01-31 at 4.10.15 PM.png

Screenshot 2023-01-31 at 4.08.52 PM.png

It has worked for the past 5 months - has anything changed that would’ve caused this?

Attaching two screenshots that shows the record list (missing +New)  and the same record list being edited (Has +New)

Thank you for the screen shots. Is this a “look up” field?

Screenshot 2023-01-31 at 4.15.59 PM.png

This doesn’t work since they’ve changed the Markdown Editor.

Ahh that's too bad. Appreciate the response!

Hey <@U03B50D2JE4> - I'm a PM at Stacker. Do you mind elaborating on what you were using this rich text block for? Always nice to know a bit more about the context of how our customers use these widgets :slightly_smiling_face:

<@U02LWNFKVK9> are there any plans to bring this back? Formatting using Markdown was pretty crucial to my UI

For example I used Markdown tables pretty regularly to format automations 

Thanks for your feedback, folks! Stacker has never supported Markdown officially (or, frankly, intentionally, though the rich text editor offers some similar functionality), but I do hope we may be able to in the future and would love to hear more about specific use cases. It might make more sense (and also be less problematic from a technical and usability perspective) to separate that from the rich text editor, though that also opens a can of worms — especially with regard to the different data sources we support. It’s definitely worth discussing though. :)

<@U029ZMZ861Z> Sounds like you might need to have your own CDN. I’ve helped two clients with that kind of need.

Here is some documentation (not updated recently)
<https://ambroise.dhenain.com/how-to-replace-airtable-public-cdn-by-your-own>

Screenshot 2023-02-04 at 11.29.09 AM.png

Hi Tyler, I’m going to send you a DM now to get some more information about this.

This is exactly our process for setting up a new instance of our product for a new client, I duplicate the database (airtable) and send the share link through to stacker support, asking them to clone the app in your workspace you want to clone, Will be done within the week and you can get to customising to clients needs!

we work with mostly manufacturing based clients - if you come across a need for a performance management system for shopfloor staff, let me know!

Hey Simon, are you open to having a quick chat about your cloning use case? I’m interested in some of the details. We’d obviously love for stacker users to make as many stacker apps as possible so we are exploring the space. If you’re open to it could you book a time in with me?

<https://calendly.com/szewing/30min-1|https://calendly.com/szewing/30min-1>

<@U02G1V7KTB6> too ofc if you’d like - it’d be great to finally chat! No pressure though :) 

<@U02LWNFKVK9> i’d be up for a natter, times are difficult for me as I’m NZ based. If you can do times that suit my timezone, I’m available to contribute. Cloning apps is mission critical for our use of stacker and the ability to manage this without having to go through support would be valuable.

Hi <@U02LWNFKVK9> I have made a meeting, cherrs

I am with Luke though, time locations aren't great haha

Thanks <@U01MPEM22RK> - I appreciate that! Really looking forward to chatting :slightly_smiling_face:

Screenshot 2023-02-06 at 2.08.29 pm.png

I’ve removed some of these in row view by identifying the elements in dev tools and display: none in custom css.

there was an assigned id I could use to target what I needed to get rid of. for my case it was .stk-card-cells-divider. likely to be different in your case and may well not have a stable id assigned to it.

Sorry to hear that <@U01QZ40HRFW> - could you get in touch with <mailto:support@stackerhq.com|support@stackerhq.com> with all the details you have and we'll investigate.

image.png

Sorry folks, looks like we're having an issue - we're on a call to investigate it, will keep you updated. I'll update you here and in <#CMZK26G76|>

Having some reports of people able to access apps, but am still waiting for full confirmation it's resolved.

Status is now fixed and monitoring, we'll continue to keep and eye on it.

<@U01QZ40HRFW> <@U03QRR8AXT2> can I check it's working for you?

Thank you for confirming, and your patience. We're still investigating this to do our best to make sure it doesn't happen again.

yes, you can pay extra for a 5-minute sync time instead of 15-minutes

I think the issue raised is more about initial page load time, not sync delay with Airtable

Have you ever chatted with support about improvements that can be made to optimise your app <@U03L6UNAQQG>?

<@U03G3BA8ZE3> Currently waiting for one of my tables to be fixed by support so I can clean out some extra fields and then I’ll reach out!

I am definitely talking moreso on page load time and not airtable sync

For sure, keep the conversations up with support - the more complex an app gets the slower it can perform, but there are some best practices that can help keep things running smoothly.

The errors are for each of the role assignments I set up. I removed the conditional role assignments and that cleared the errors, but I need the conditional role assignments to work. Any assistance would be much appreciated.

Issue resolved thanks to Stacker support. I needed to enable the Stacker Roles field in my Users table.

Anyone had success in hooking up Google Auth to your Stacker App?

There isn’t a list of support Markdown as Stacker doesn’t officially support it, though we have been able to get some “Markdown/Textile”-ish functionality “for free” as part of a 3rd party library we use for rich text, and therefore what’s supported is what’s available in the rich text editor UI there. That said, I would love for us to support the Markdown standard in the future, and we’ll be discussing that along with may other features our our wish lists.

Hey Joel, we're working on this and will have a solution in good time ahead of the change. Please *don't* swap to a personal access token for now though

Copy that! So glad I asked. Thanks for the heads up.