Stacker Customers

Airtable status page just updated :upside_down_face:

Screenshot 2023-04-27 at 10.27.20 AM.png

<@U01QZ40HRFW> could you please report this through the support widget? We’d love to take a closer look

Hi <@U018AL5U830>, would you mind reaching out to Support directly through the question mark on your Stacker app, so we can take a look at your app? Thank you :slightly_smiling_face:

To clarify, as I suspect others may have similar questions, after upgrading an Airtable connection to use their new API, there isn’t a set sync interval, but rather their API sends changes when they happen — it’s not instantaneous, and we’re working with Airtable to try to avoid rate limiting where possible.

yes I will reach out via chat.
<@U03RT7UAPPU> to clarify my observation - automations will run in airtable and it will still take several minutes for them to be reflected in Stacker.

That’s really interesting. I wonder if Airtable isn’t interpreting that as data having been changed and therefore not sending an update. :thinking_face:

<@U03RT7UAPPU> I’ve noticed something similar.  Seb and I have tried to debug it a million different ways and I think y’all have made some good headway.  <@U018AL5U830> does the automation affect the main record or related records?  I notice this specifically with related records.

I will pay attention to these things (automation vs direct and main vs related) today while I’m working and report back!

Is it supposed to also push a page refresh?

or is the update supposed to only show on refresh

That’s good to know, thanks for bringing this up, I’ll wait a bit before migrating to the new API :grimacing:

<@U018AL5U830> testing it now since usually i’m movin a million miles an hour and don’t really pay attention. It took 3 minutes for an automation to show up on the main record.

*test 1*
*Conditions:* Manual update in airtable, main record, without refreshing page in stacker

*Total time before update appeared:* I cracked and refreshed the page at 5 minutes and the data still wasn’t in there. It finally showed up after 9 minutes (without manual refresh). I don’t know what’s happening since I used to have 5 minutes sync. Support may be doing something with this app related to this so I’m not sure this test is relevant.

just pinging <@U02N890SW84> since this seemed similar to what I was experiencing (although it was fixed on my end)

Thanks for the reports, folks.

I would suggest that we keep these types of conversations (bug reports) through the support widget. That way we can make sure that your problem doesn’t get diluted with any others that might be reported.

It is common for completely different problems to have similar symptoms, so we would prefer to look at each of these issues in isolation.

We definitely want to take a look at all of them and see what we can do about it. Please do keep on reporting them. :simple_smile:

Sounds good! When I first brought this up I wasn’t sure if maybe there was something I wasn’t understandinga bout the new sync. Anyway, I already have a ticket open and will continue there. Thank you.

Amazing, thanks heaps. :bow:

There are some limitations, though I’m not sure that you are hitting them here—we will have an article about it early next week :simple_smile:

Can you clarify? I’m not sure what you’re referring to.

I ’ve been told that you will implement Auth0 on early 2023 and this enable the 2FA login.

I have a huge interest in this feature : <https://stacker.canny.io/feature-requests/p/2fa-for-loginmulti-factor>

Can you give me some info ?

We’re pretty busy with the new Airtable API right now, so I don’t know about that.

ok. And do the new airtable API will help to add security to the login (2FA, and session limit duration ) ?

The Airtable API is for sending and receiving Airtable data, and required going forward since the old API will be deprecated.

Hi <@U055D1TDU2Z>, one thing to double check would be where the linked fields are connecting.  You can also reach out to support in the app using the ? on the bottom right and we would be more than happy to look at what might be happening! :slightly_smiling_face:

hey everyone, does anyone know of a way to achieve this? <https://feedback.stackerhq.com/feature-requests/p/show-all-tabs-if-there-is-enough-room>

I’m not sure there’s a good way to do that logistically, and regardless from a privacy perspective I don’t know that we should be discussing information another person provided to us with you even if we were somehow able to make that connection — after all, if they want you to know, they could share it with you themselves, and even CC you in their emails.

That said, I definitely appreciate your perspective, and it’s something we’ll discuss. I think it’s important to keep in mind that in general when a person sends an email to another, the presumption is that a third party won’t have it shared with them without their express knowledge and consent, regardless of any personal or professional relationship that may exist. I think that’s an important “default”.

#2 seems like a completely separate issue, and something we can delve into via support, since it will inherently require delving into the specific situation and app(s) involved. We haven’t had other reports like that though, if that provides some context.

I sent you a follow-up video. Perhaps our organization sets up support differently from others, but my team members are the only ones who can reach out to you. They handle tier 1 and tier 2 issues (records aren't loading, etc.). When something becomes tier 3 (i.e. Stacker says that it's a permissions issue, but we haven't made any changes to permissions and I need to follow up and figure out what happened on a development level), then it gets really tedious to gather all the details they've already submitted about the issue.

:sweat_smile: wait that sounds like the support system we built out for our organization!

But seriously, even if they didn't want to build out a custom system ... I think the Stacker team is using Intercom. When we demoed it for our org, it seemed like we could have preset groups. And if users were submitting from the same email domain, I wouldn't think it would be too difficult...

Not right now, but we’re hoping to provide a better experience in the future. Could you possibly explain your use case better—why would you like to change the colors?

Hi Ryan, I’m looking into improving our charts feature at the moment – would be great to hear what you’d like to see here, either specifically on colours, or any other wider charts feedback if you’d like to share. Thanks!

We don’t use the charts… yet. But we take color fairly seriously at Gaingels. Color can communicate a lot about an organization. Drab colors versus primary colors versus pastels… red versus green when dealing with financial numbers…  they all subtly communicate different things,

Ideally there would be an interface where one sees the total number of colors used in the chart and one can accept default colors, assign colors from a number of preset palettes, or assign individual colors for each segment that uses a color.

<@U02BT5MDXEV> thats awesome to hear! From my perspective, it really comes down to branding and making sure that everything is within the same color schemes, so being able to select colors for all components within a chart would be great! The other would be the ability to have bar graphs in different orientations and to be able to add multiple data comparisons side by side. The one thing that drives me crazy right now is with the number charts, and how you can't make them any smaller and if you only have one number chart for example, you can't center it on the page, by default it is just to the far left. Would also be amazing if you could change the color of the background of the number chart boxes to any shade to make them stand out etc.

Thanks for the comments <@USCPEEY8P> <@U03LREH528K>, this is really useful to know :+1:

CleanShot 2023-05-01 at 12.15.28@2x.png

Hi <@U045AV7A57A>, you can try using the formula field on Airtable with the record ID similar to using the <https://support.stackerhq.com/hc/en-us/articles/4409799378835-Auto-filling-values-into-create-forms#how-to-use-your-auto-fill-url-0-4|Autofill URL.>

For example, you will need to create a field for the Record ID function in Airtable then another field for the formula: ‘article-home/view/aho_‘&amp;{record iD}

The three letters can be found by by going to the page of the user and it is the three letters before the ‘_’

image.png

I guess my question is,  for each view, I need to build a different formula?

In our case for User Profiles, I have 4 different views.  Our users basically have a view available to them based on their role.  So User 1, has access to view "All Users:.  User 2, has access to "Project Ascension Group Members",  and so on.

apdpportal/all-users?row_id_base=uac_recP4C2FXGOzSwPu5

apdpportal/user-accounts/view/uac_recP4C2FXGOzSwPu5

The detail pages will all be the same for all, including the URL, it is based off the parent navigation item.  If you are trying to navigate to the List View that is specific to them you would type the name of the layout manually.

Hi <@U050DT32RLJ>, could you send this into support via the widget in app? That would help us take a look at this.

I did a few weeks ago, can do it again though. Thanks!

Using Safari normally that would not happen, but using Private browsing mode and/or clearing website data/cookies would cause that. That would be a good starting point to get them sorted. :)

CleanShot 2023-05-02 at 09.43.14@2x.png

CleanShot 2023-05-02 at 09.41.37@2x.png

Hi <@U0393AW3D37>, you can use the field widget and start it in collapsed mode.

Under edit layout, select the Field widget, select *Options* and check the box for Allow sections to collapse and expand and start collapsed. If you change the name of the *Section,* this will be the title that shows when collapsed.

You can then set a conditional visibility filter for the role that can see this field widget.

Hope this helps! Someone may have another workaround for you as well :slightly_smiling_face:

Thanks <@U040KEGR3RA>. I implemented that already. But don't want to sacrifice the integrity of layout - hoping to have field level control. Will hope someone else has a suggestion.

ok I will investigate such <@U0146FKFCKE> thank you

Roles are just a way to easily assign permissions to a group of end users automatically using a filter. The simplest form of this is having a “role” field in the user table and assigning a role to each individual user based on the contents of that field in their record. You can have the role determine which tables they have access to, for example: <https://support.stackerhq.com/hc/en-us/articles/4409591860243-Set-up-User-Roles>

<@U03RT7UAPPU> Perfect! And I can set it so the end user has no access to view the role name, right?

Correct. That’s just part of the Admin UI. So unless they’re an Admin in the app or you give them access to the field that determines their role and it uses the same terminology, it won’t be visible to them.

Multiple tick list view.png

Tick list view.png

You mean like this? It’s easy enough to include an attachment in the list layout, however, as the examples show, it does not work well if multiple images are included in a single attachment field. Would be nice to have more control over how both individual images scale and appear, as well as how multiple images get handled.

I've not heard any reports, I'd say it's worth messaging support to get this looked at.

Thanks Oli - yeah it seems to be one app has lost connection to Airtable.  Escalated to support as you suggest.  Cheers.

And just like that - the awesome support team fix the issue.

Ironic that I said on last weeks ComCall that the buck stops with me when things go wrong, but in this case, Stacker Support were the hero's of the hour :smile:

CleanShot 2023-05-04 at 09.30.24.jpg

We're looking into this, if anyone else experiences this please do get in touch with support.

Mine didn’t get removed but there are no records there anymore so I had some panicked calls in the AM about the issue :slightly_smiling_face:

<@U03G3BA8ZE3> possible to keep this thread updated? I’m getting quite a few complaints this morning so want to manage expectations

We'll keep you updated via Intercom and will update here as well when we have a fix. There's no time frame at the moment though.

Hey folks! We’ve made some changes to address the issues y’all were having. You should be good to go now after a Shift-Reload, but be sure to reach out if you encounter any further issues. Cheers!

also validation, like making sure an email is not malformed

Uniqueness, not at Stacker level
Format, possible using JS, but not straightforward (not no-code)

Uniqueness can also be done by JS, but it’s not no-code

I'm a programmer, so it shouldn't be a problem

If you end up buying a Pro plan and you want to get started quickly on JS scripting, that might interest you
<https://dna-pc.notion.site/Streamlined-JS-scripts-deployment-pipeline-CI-CD-GitHub-1964ab13d7ba4311be9cda240c467e05>

<@U042LH2HY1W> Hi Adam—our charts are a beta feature, which is why there is no documentation.

We do not support multi-select fields on the charts, but we do single-select fields.

Right now we support:
• Text
• Number
• Formula
• Single-links
• Single-select dropdowns
Could you possibly help me understand your use case better? What exactly are you trying to filter by?

<@U04UPPZEP54> This has happened to me before. It was usually a look-up field that caused the issue.

If I recall correctly; I was linking records based on a lookup. It is best to reach out to the support via Chat they will help you identify the field that is causing this.

hi <@U04UPPZEP54>—I believe we are looking at this through the support channel, so we’ll reply there. Thanks for the report!

Hi Josh, not at the moment - but could you add this as a request on our <https://feedback.stackerhq.com/|feature request board>? Any extra context about how you want to use it would also be appreciated.

Screenshot 2023-05-08 at 5.48.01 PM.png

Screenshot 2023-05-08 at 09.19.39@2x.png

This is determined by the Display Name of the table. You configure that in the table settings here:

In the table settings you have to set the created by field to current user. You'll need a created by field in your database.

Yep! And the Created By field doesn’t even need to be visible: <https://support.stackerhq.com/hc/en-us/articles/4412328252563-Created-By-Field>

But does that mean the User has to be in Airtable as well? My user database is pulling from salesforce

You could setup links between tables: <https://support.stackerhq.com/hc/en-us/articles/4409598238099-Creating-links-between-tables>

Awesome. I thought this was still planned.

If you also provide a "last updated by" it would be even more awesome, since we often pre generate records that stacker users take action on. Since this is often only one user I am only interested in the last person who did the edit.

<@U050DT32RLJ> Thanks for the report—contacting support is indeed the quickest way for us to look into an issue. We’ll get back to you as soon as we look into it. :simple_smile:

From what I can tell my calendar view works fine, but the team will investigate this further when they take a look at your setup

This issue should now be solved—thanks for the report!

Looks really bad because it's the view my users need the most

Already notified support, posting here for visibility

Screenshot 2023-05-09 123948.png

Hi there! What does your CSS look like now?

The classes we properly support are in <https://support.stackerhq.com/hc/en-us/articles/4409598258579-Custom-CSS#current-class-list-0-1|this article>

Hi, my css right now is changing the background color. I have tried using the Main navigation, User menu to change this menu. I am assume these class edit something else and not the menu in the image

You can try
```.admin-app-nav-menu {
  background-color: [your color];
}```
You can also look at classes you could use through the browser’s developer console. If you’re not savvy with CSS yet, I would recommend <https://www.w3schools.com/css/default.asp>