Y_K - profile

Y_K · Nov 16, 2022

I use Notion as a notebook to keep track of the formulae I’ve written in Airtable, it has a handy “code” block to highlight language syntax. Does anyone know which language I should select that’s most similar to Airtable formula syntax? It doesn’t ha...

Y_K · Aug 09, 2020

I have a “citation” field for my “article” record, an article may refer to several citations, e.g. Book A, p.57 and Book B, p.327. Obviously I also have a “Books” table with book name and published year, author etc. But I don’t know how to associate ...

Y_K · Feb 27, 2019

The Tesla example base seems to have disappeared, anyone made a copy of it and could share with me? Thanks!

Y_K · Apr 06, 2018

Excel uses LF as newline character within the cell. When copying multiple cells from Airtable to Excel, it seems the multi-line cells display correctly, but the new lines are actually saved as CRLF instead of LF in Excel. This would cause problem whe...

Y_K · Mar 04, 2018

I can get a list of field names by downloading the CSV and look at the header line. But is there a way to get a list of field definitions (field type, formula details?)

Y_K · Nov 09, 2021

Suggestion: Inconsistent text boxes on interface. An empty single-line text field shows an empty text box on interface An empty multi-line text field shows “Start typing…” in the text box on interface. Would be nice if the two are consistent (i.e. do...

Y_K · Aug 13, 2020

Thanks – that’s actually what I have done (create the citation table linking the other two tables) but the user has difficulties adding an association. I guess this is the only way unless I design an external UI to help simplify the data input. Thank...

Y_K · Mar 08, 2019

Add BLANK() to your IF statement. IF({Publish Date},DATEADD({Publish Date},-7,‘days’), BLANK())

Y_K · Mar 08, 2019

Hmm… I also think creating 47 custom views is the easier approach (unless you suddenly get like 200 different new position types), the Airtable UI is easy enough to let people play with filters if necessary – and I don’t expect the filters to change ...

Y_K · Mar 05, 2019

Add a BLANK() to your IF function: IF ({Last Delivery}, DATEADD({Last Delivery},1,‘month’),BLANK()) Then choose the Date Format in the second tab:

User Statistics

User Activity

Keeping Airtable field formula in Notion as a backup

Design question: a citation field with page numbers

Where has the Tesla example gone in Airtable Universe?

Copy & Paste to Excel adds unwanted CR character

Can we get a list of field definitions of a table?

Re: Introducing Interface Designer 🎉

Re: Design question: a citation field with page numbers

Re: Can't use a date calculated by Formula Field in Calendar View [SOLVED]

Re: Compare two columns and find matches?

Re: How do I add DATETIME_FORMAT to this formula