Stacker Customers

you should be using the RecordID from stacker is looks like “table_recxxxxxxxxxxxxx”

<@U018AL5U830> for my Student table, the Stacker record id is akin to `stu_recXYZ`

Could you clarify what you mean here <@U0534ACTYE5>? An example of what you’re looking to do would really help :simple_smile:

sorry for late reply, <@U02N890SW84> . what i have in mind is something like checkboxes in a record list, marking records for a button-triggered action to be applied on all of them.
for example, if i want to delete a bunch of records matching certain criteria, i have to delete one by one. unless I'm missing something..?

to clarify further, for example, we have a need to assign students into a group. we'd filter out student records by a certain cryteria, and then we'd like to bulk-assign a group. currently we'd need to open each student record and set a group membership one by one.
is there a way to make this faster (i.e. for-each loop/mass record update kind of solution) in stacker?

Screenshot 2023-04-18 at 10.05.12.png

<@U0534ACTYE5> Thanks so much for the explanation and sorry for the tardiness of my reply—I was out on a short vacation. :palm_tree:

There isn’t a way to perform bulk updates on list layouts in the app. That said, you can delete multiple records at the same time through the admin data grid. When you hover over a record, you can select it. Here’s an example from my test app.

When it comes to bulk editing in any other way, I can definitely see a need for it. I see you have alread voted for the <https://feedback.stackerhq.com/feature-requests/p/add-bulk-edit-options-to-lists|feature> on our feedback board. :simple_smile:

image.png

We haven’t seen any other reports like this, but if you contact support we can take a look!

I managed to login with my email directly (by requesting a login code :shrug: ). I see that the response is 500. I’m a bit in a rush now to fix some things, so I won’t be able to get to support now, but thanks for a quick response!

I see a possible bigger issue though :smile:

No worries, I’ll see if I can find anything.

Sync was not working for 4 hours, so likely I will have to reach out soon to support

Yes, another customer reported something similar.

Got it, thank you. I assume you will notify somewhere in status about it?

We’re trying to determine the scope, but yes it’s possible

It can take some time, but if you get in touch with support, we can look into it.

No, not at the moment. And I can't find a feature request for it, so please do add a new one if you have time! <https://feedback.stackerhq.com/>

Capture d’écran 2023-04-12 à 16.58.52.png

Not sure if something has changed here, will find out!

Hi <@U0475GGUN2J> This has now been fixed, you should be able to put images and text on the same line again! :slightly_smiling_face:

Fantastic <@U040KEGR3RA>, it’s well agenced

I don't believe it's possible out the box, there may be some code that could help out here but I'll let the code-savvy members of the community comment on that!

Hey Ed, would you mind sending this question in to support via the widget in your app? They'll be able to help answer.

Are you talking about linked fields specifically <@U04J8F25MFV>?

I was thinking of linked records and lookups

Have you tried exporting anything in the last couple of days? Could you give it a test just now?

Please do pass on your thanks to <@U02BT5MDXEV> - see this <https://stacker-customers.slack.com/archives/CMZK26G76/p1681391144607429|post> over in the <#CMZK26G76|> channel :slightly_smiling_face:

not nearly as clean solutiuon, but browsers (chrome, at least) can follow a link generated via right-click a selection and then "Copy link to highlight"
e.g. <https://www.lipsum.com/#:~:text=Section%201.10.33%20of%20%22de%20Finibus%20Bonorum%20et%20Malorum%22%2C%20written%20by%20Cicero%20in%2045%20BC>

not sure that works in your case, though

I saw that the other day in the flyout and was wondering what it was. Thank you! If I don’t use it now I’m sure I will in the future.

Hey <@U03L6UNAQQG>

While we don’t support anchor links, you can vote for the feature on our <https://feedback.stackerhq.com/feature-requests/p/anchor-menu-to-detail-view|feedback board>

Hi <@U01C2DKQ0LX>

No way to change right now, but you can vote for the feature on our <https://feedback.stackerhq.com/feature-requests/p/customize-record-label-in-data-widget-on-custom-pages|feedback board>

You could probably build something similar with a conditional text field that shows up if someone has already submitted a request, that displays a computed field with your message

I do this currently - I have a hidden checkbox field that is marked as TRUE upon submit of a form / or based on the status of the request.

I have a “Call Out” that is conditionally displayed based on this check box.

Once the request has been updated internally, the Call Out is hidden and a new Call Out is displayed with actionable items regarding the request.

but doesn't this solution keep the element displayed? for example, if i open record, submit it for review (call out appears), then go elsewhere in the app, and then get back to the record, the callout woulds still be there, right?

You are correct it would still be displayed as I currently have “Request In Review” which stays until the request comes back.

• You could make a formula based on last modified and only display the field dependent upon a certain duration beyond the receipt of the form.
• Or trigger an email confirmation upon receipt on the modified record/field in airtable or using zapier.

Or a third option would be to embed a third party form that has a confirmation receipt page to accept the data and send to Stacker / Airtable / Google sheets with Zapier

Screenshot 2023-04-14 at 4.19.44 PM.png

Screenshot 2023-04-14 at 4.19.30 PM.png

<@U0534ACTYE5> It’s because this option looks for Airtable fields that are of Attachment type. You need to have such field for the option to show up

<@U0146FKFCKE> does it need to be airtable? can it be another data source? one of the beta ones, salesforce, postgres..
also, does the attachment field need to be in the same table as the displayed record, or anywhere amongst the sync tables?

Needs to be in the same table.

Regarding the data source, I am not sure, I believe it should work with any of them though.

It can just be a stacker field, which wouldn’t need to be in your AT dataset.

You can either just use a single image or create a formula to change the image based a variable within the record.

<@U03L6UNAQQG> can you please point me to a help article discussing your solution? i mean, i'm familiar with formula fields, but they can't contain binary (i.e. file/image) content, right..?
this would be a great help to my solution, so if you could please clarify a little bit more. thanks!

I apologize - the formula solution is not possible for native headers / I use that as a workaround to display banners that I need to change daily through formulas. I use the “Highlight” field to display the formula that is dependent upon the current shipping schedule.

 I am attaching a view of what this looks like - it is more of an informative banner than a header for visual pleasure.

Screenshot 2023-04-16 at 4.43.24 PM.png

I also have a zapier automation that uses the Native banner field - this takes the logo entered,  stacks the images and generates a banner to upload to the Airtable Attachment field upon creation.  Attaching here

<@U0534ACTYE5> <https://support.stackerhq.com/hc/en-us/articles/12085622508691-Stacker-Fields-|Stacker Fields> help doc article is the solution Tyler mentions. You could store the images _just in Stacker_ rather than in your main database. This may work for you, depending on if you need the images to be both in Stacker as well as your data source (or not).

<@U03L6UNAQQG> I'm curious what tool you use to automate the image creation? Looks great!

<@U03G3BA8ZE3> thx for the clarifying bits. in our case, though, we need the images to be dynamically assigned from source db, via link or so. not sure that's possible with stacker (?)

Ah ok, in that case Stacker Fields wouldn't help. What db are you using?

salesforce, but we could switch maybe for a different one (postgres) in the future, should that make sense.

I'd say it's best to ping support to ask about this via the widget at the bottom right of your app, sorry I can't be more help here!

<@U03G3BA8ZE3> Using BannerBear for a quick image generation via query string. I use it quite a bit if you look around in my apps :slightly_smiling_face:

You can also do this nativley in Cloudinary with their layer_ parameter - but I use Bannerbear bc it saves me time making templates on the front-end.

That's really cool, I haven't come across BannerBear but definitely could be useful for one of my projects!

Hey <@U03LREH528K>, CSS doesn’t apply to the `<http://workspacename.stackerhq.com|workspacename.stackerhq.com>` login page. Having said that, we’d love to offer more customization options for the login page in the future.

If you haven’t already, you can <https://feedback.stackerhq.com/feature-requests/p/edit-the-login-page|vote for the feature> and mention your use case on our feedback board.

I would also be in favor if there were more options to customize the login page. I don't need the Google login either. I also need to see that I haven't figured out how to even link my stacker account to the Google account to use the Google login.


Are there any work arounds to this? It's going to cause massive confusion if my 1,000 associates see a Google login prompt rather then just putting in their work email address.

There is not. Is there a particular reason that folks logging in using Google would not work?

<@U03RT7UAPPU> my app is for employees only, with only work email addresses

Hi <@U03CY3BH3DK>, well spotted! We're starting to roll out the Airtable data connection upgrade to some accounts. You can read more about the upgrade here: <https://support.stackerhq.com/hc/en-us/articles/14372703347219-Upgrading-Airtable-data-connections#airtable-data-connection-upgrade-explained-0-0|Help Docs: Upgrading Airtable data connections>.

Duplicate is the little button just to the left of the dropdown you clicked - does that work for you?

If I’m understanding you correctly, and you manually (or using an automation) to add the links to an embed, that’s not something Stacker can update for you.

Stacker will automatically refresh attachments _in the table_, but when you’re using something outside of that which Stacker cannot sync from Airtable it’s inevitable that the links will expire.

It sounds like you may have already worked around that by using an automation to grab the new links either from Airtable itself or from the table data Stacker is syncing to refresh periodically though, so it sounds like you should be all set.

Ok, good to know. For anyone who is wondering how I did this, I created a webhook trigger using <http://Make.com|Make.com> for whenever an embedded Airtable attachment (like a PDF document) is requested, resulting in a fairly automation cost overall, since it’s request based: <https://www.youtube.com/watch?v=mCeTIGeegcQ&amp;t=135s>

Stacker does not have radio buttons, but you may find this useful: <https://stacker-customers.slack.com/archives/C01CH3HCZR9/p1680993017782709>

You can also vote on the feature request here: <https://stacker.canny.io/feature-requests/p/radio-buttons-for-single-select>

Depending on the context, one or the other may make more sense. :)

<@U03RT7UAPPU> thx for the suggestions. i'm aware of the css method, which is quite nice, however, each checkbox represents a single choice in each answer, which would mean we'd have to have a checkbox for each option in each question, and that'd be just way too many.

Ah, got it. That makes sense, if there are a lot of them it would be a bit of a pain — though I believe a multi-step form could work for your use case, even if not your ideal solution: <https://support.stackerhq.com/hc/en-us/articles/4412621173523-Creating-multi-step-form>

i'm afraid that wont work either - the users are students and we're building a food ordering interface. that means there need to be a way to order a particular meal option (out of 6) for each meal of the day (2-3) for each day of the week. i'm afraid nothing else but radio button will work :confused:

Screenshot 2023-04-19 at 16.10.07.png

Aha, the context makes all the difference! Thanks for clarifying.

So, I know from experience that it isn’t super user-friendly, but a lot of the time when I’ve selected an inflight meal from an airline’s website, it’s just been in a dropdown menu. Are you sure this wouldn’t work?

(On the plus side, as much as I don’t like this UI particularly, it has the advantage of making it easy to select an option for multiple meals, on multiple days at once, if desired, and also scales rather well.)

interesting.. what do you mean by "multiple days at once"?

Screenshot 2023-04-19 at 17.28.53.png

There are so many different ways you might need/want to set something like this up, so to keep it simple I just mean having a form that the student selects from for multiple meals on multiple days:

Could you create a new action button to edit the record rather than the built in Edit button? You could then create two identical buttons that will appear: one if they're an admin, one if the other case is true.

Hi Ruchika - you could do what M Lowell has stated, which is good because it is native.

Alternatively, you can use a 3rd party form to update the information using an embed widget.

<@U04CS4F3FNG> A custom action button will not take the user to the Edit Layout, that would have been perfect otherwise.
<@U03L6UNAQQG> need to keep it consistent to the Edit across other tables.

Hi Linda, do you have the settings set to be “only show related records” or are they set to “show all records”? Sorry I hit the enter button too early :sweat_smile:

Hi Brittany, I have it set to show related records only

Thank you! The “add new” button will not show if it is the Linked side of an Automatic link field.  You may also try choosing the link from the other direction when you are choosing your options in the drop down.  If this does not help, please reach out to support so we can look at your app specifically :slightly_smiling_face:

This is how I defined the Help Desk Notes table

and this is what ended up in the Help Desk table

Are you saying I should have done the link from the Help Desk to the Notes table?

CleanShot 2023-04-19 at 13.44.20@2x.png

On “Help Desk Notes” can you change this to “Link to multiple records?”

If the connection starts with the table you are on to define the connection the Add New button should show, in my example below, when I use the “Events” table connection I can add new, but not from the “Students” connector:

Thank you very much!  I have it working now

Hi Sara, one possible solution: Could you have two buttons that look the same, but go to the different links, and then use conditional visibility to make them appear for specific roles? IE

Button 1: Links to <https://company.stackerhq.com/nameofmyapp/bureau> and is only visible for admins

Button 2: Links to custom.domain/bureau and is only visible for users

Yes I can ..and I will. So it’s sure there is no solution with a *relative* *path ?*

Can I just check, is this a button in a detail view or somewhere else?

I ask as a Quick Link widget might work, depending on the circumstance. You can link to internal pages with them. Let me know!

Ah great, it’s exactly that : a link to internal pages.
Many thanks

Hi <@U050DT32RLJ>, not possible yet, but you can vote for the feature on our <https://stacker.canny.io/feature-requests/p/add-the-ability-to-move-a-nested-view-to-top-level-navigation|feedback board>.

Screen Shot 2023-04-22 at 11.17.01 am.png

anyone else have issues with "preview as" not working?

it is working for me. Definitely submit a support req in app if you haven’t

Thanks for the shout <@U03L6UNAQQG>

Sorry for the trouble <@U01MPEM22RK>—we’ll be happy to take a look if you contact us through the support widget. That’s the question mark icon &gt; Contact Us in the app

This happened to me as well for two apps so far. I’ve sent a report request on Friday, <@U02N890SW84>

<@U01JV1M8PS8> It seems like your ticket was with the engineering, and they believe they issued a fix. I just replied to you.

Please note that similar symptoms might not equal to the same issue

You can conditionally import data from Airtable to stacker using Data filters- can you explain your use case?

use case is in Airtable a cell is colored red because value is less than zero. I want either the cell data data in Stacker to appear red, or the entire row to appear red based on this condition

but I don't want to manually import data. I'm hoping this would happen automatically, similar to how Stacker now displays a colored picklist value in Stacker the same way it is colored in Airtable.

and thank you <@U03L6UNAQQG> for your help.

<@U0393AW3D37> Here is a potential workaround -

1. Create a formula field in Airtable called “Number Card BG Color” with the formula  `IF({Airtable Number} &lt; 0, "f43434", "ffffff")` where {Airtable Number} is the field that holds the number -

In this case, the Background Color will be f43434 (red) if number is less than 0, or ffffff (white) if it is greater than 0.

2. Create a field in Stacker called “Number Card Image” with `"<https://dummyimage.com/300x100/>" &amp; {Number Card BG Color} &amp; "/ffffff.png&amp;text=" &amp; {Airtable Number}`

3. Show the “Number Card Image” field where you want to display it and check “Display URL as Image”

Note that the image size can be altered by changing the 300x100

Let me know if you need assistance along the way if you use this

The custom image works, although it doesn't color your whole row. You can do something more fun with the "color" by adding shapes to the image to make it more intuitive (see attached image).

In my scenario I am using a linked record in Airtable + a lookup field to choose which image should be displayed. That way your images can be stored and updated directly in your dataset.


You should also note that single-select Airtable fields can now display their color in Stacker (see second attachment). Again, it doesn't color the whole row but is pretty easy to work with.



If you need something more advanced you may also be able to use custom JavaScript to change the row color based on values after the page has loaded. I have very limited experience with things of this nature so I can't say exactly how to do it. I can say that it is possible to extract data from the HTML with some JavaScript and add styling overrides, after the page has loaded.

One big challenge with this is that switching between pages within the same app will reset your style overrides and you need to run your JavaScript again. The only way I got this to work in my app is to have the script run every n seconds on the entire app. It results in a slight lag after loading the page but does work.

Screenshot 2023-04-24 at 7.50.45 PM.png

<@U03R5ULKZGX>  It will color your whole row if you use wider size parameters and the “Rows” Display type (example Attached with left alignment on the dummy)

This was meant to be a simple solution that most people could do with copying and pasting. I will provide a much more in-depth guide in a few weeks that explains how to make it look less “bleh”

<@U03R5ULKZGX> this technique is perfect! Different need for me, but I love this.

We need a no-code specific GitHub <@U0146FKFCKE> :sweat_smile: (I think I've seen a few people working on this!)

<@U052YPJRJ05> Do you have a specific app that you've built to track things across different tools?

GitHub isn’t complicated, it’s just files and folders, you just need a good UI tool to do the commit/pull/push stuff.

With files/folders, I store over 1000 formulas/rollup fields, all indexed by their name. Automations, too.

Airtable, some Stacker configuration (scripts, css, etc.), Zapier, Make, PipeDream, everything goes into the GitHub repository, and I can find where a field is used across all those tools in a single cmd+f search.

Simply marvelous, no other tool give me this kind of overview.

Having databases over 2.5k fields, I couldn’t rename any field I had not this system in place. I wouldn’t be confident not breaking something.

That's super impressive, I'll admit I'm not great at documentation and it sounds like you've nailed it. Must save a lot of time in the long run.

Within Stacker tables, how about we start by adding an “Info” field to define and add meta data to the field’s column name and then offer up a “Manage fields” layout where this descriptive data is displayed and can be modified. This could include permission and dependency data like Airtable does too. The more Stacker self-documents, the better IMHO.

Yes, I like that idea. I think the thing I struggle with (that Ambroise has figured out a system for) is mapping out processes across multiple apps, eg Stacker / Zapier / Airtable / etc.

<@U03G3BA8ZE3> We did previously, yes. But to be totally honest we found using the Airtable Interface to be faster from a user-standpoint, and also simpler--we just didn't need a full blown Stacker app for it.

That makes sense, I tend to use Notion for simplicity for the limited documentation I do. Making it easy to update and read is key!

I believe it's not possible at the moment, it's not in our supported list of CSS classes. Could you add it as a <https://feedback.stackerhq.com/feature-requests|feature request>?

Hi Peter, it is not possible to make a Formula field a Primary field at the moment!

You can change the primary field by going to “Settings” &gt; “Display Name” &gt; Choose the field you want as your primary field. :slightly_smiling_face:

It's something we're looking into re FF as primary field!

I have a very old feature request from the day they released calendar view pointing out that showing a calendar month isn’t useful –it should show the last week, this week, and the next 3 weeks, regardless of the date.

in my case month is actually ok because this is an event that spans the entire month, I just wish it was a little taller

Yeah, different use cases. Imagine though if you’re trying to give users a view of upcoming events. And it’s April 26th. Like it is today. They would mostly see the past and have to click to the next month to see what’s next.

Not possible at the moment <@U050DT32RLJ>, please do upvote and add any extra context here though: <https://feedback.stackerhq.com/feature-requests/p/change-height-of-calendar-view>