Andy_Lin1 - profile

Andy_Lin1 · Jan 26, 2022

Update (2022-02-11): The stylesheet is now designed to be used “out of the box” to restore the look of the original expanded record view. (Unfortunately, I’m working off my memory of what it looked like so it may not be an exact replica.) Here’s what...

Andy_Lin1 · Jul 22, 2019

I tend to have a number of Airtable views open, each with a different focus. However, the default Airtable only says (Table Name) - Airtable. I’ve written a Greasemonkey/Tampermonkey script that will change the title to (Current View Name) / (Table N...

Andy_Lin1 · May 14, 2018

The sheer amount of whitespace in Airtable has always bugged me a little, so I’ve been making little edits to the stylesheet here and there to get more data on-screen. Below you’ll find some screenshots of what I’ve done and the code required to make...

Andy_Lin1 · Nov 25, 2017

I recently had to build a table to manage a number of events that happen outside of my time zone, and I thought I’d share what I’d learned in case someone else needs to do the same. Now, Airtable offers quite a few functions and features to handle ti...

Andy_Lin1 · Nov 08, 2017

I’ve seen people embed parts of a base as part of their solution in the forums, but I can’t seem to figure out how to do it myself. The share link creates a standard “link preview”, and the iframe code seems to be ignored entirely. Anyone know how to...

Andy_Lin1 · Dec 08, 2022

Hmm, I'm having trouble understanding your table. From what I can tell, you have four fields with data: Task, Date, Yes/No, Frequency/How Often. I'm not sure what "Næste gang?" is, since what you describe sounds like a dropdown that interacts with a ...

Andy_Lin1 · Dec 08, 2022

If I'm understanding your question correctly, you want to sum the values of the column. The formula you have (which, I'm a little confused by, because the field name of the SUM function doesn't exist in your screenshot) will sum the values of the spe...

Andy_Lin1 · Dec 05, 2022

Wow, that's a pretty slick interface – makes me wish I was having lunch in HK! Since you'll be dealing with a number of clients, it sounds like it's worth the effort to set up a system that doesn't require daily manual input from you. I haven't used ...

Andy_Lin1 · Dec 05, 2022

An automation would be the easiest solution (and you can set it to trigger once a day or anytime the "Main (from Set)" field updates in a record, but it does require you to have a Pro plan.You can manually set up an extension or script to perform a s...

Andy_Lin1 · Nov 23, 2022

So if you use .json() instead of .text() on response, you’ll get an object, structured roughly like { "records": [ { // first record "id": "rec***********" "createdTime": "2022-11-23T********" "fields": { //fields use name ins...

User Statistics

User Activity

Custom CSS Stylesheet for New Expanded View

Set Page Title to Current View Name

Better Whitespace Use with Custom CSS

SET_TIMEZONE and other time-related quirks

Embedding Base View in Reply

Re: Keep Record setting when formula runs

Re: Sum up values if value is the same

Re: How to change a dependent column to be independent by using formula

Re: How to change a dependent column to be independent by using formula

Re: Airtable Script: Assigning Variables to API Response