+1 for our business! We need to be able to 1) change the displayed title of the calendar event and 2) hide or re-order fields displayed when expanding events.
I have just worked out how to do this. Go to Customise Field Type, and change the field to Formula. Then, create the formula that will take the required information from the other fields in the entry.
There is some useful (if poorly explained) information if you search Airtable support Using a formula in the primary field (I included the link to that, but in their wisdom, Airtable don’t allow links in these posts!)
Quite difficult to work out what is required, maybe Airtable will rewrite it so that it is easier to understand, but a bit of trial and error - or phone a friend! and you should get there.
Essentially, the formula you choose will be for every entry in that field, so for instance if you ask it to take information from the name field and the date field by writing the formula {Name}&" " &{Date}, then it will show those two together. (e.g. James 31/01/2020).
I get the impression that Airtable can do a lot more, but I would invite them to rewrite their support section in plain English and with more examples, it would make things very much easier, and then even us non-excel-gurus can get the benefit.
Thanks @Al_Cowie - with a bit of work and lots of juggling I made a new (copied) Table with a Concatnated composite field for the AirTable key ( AMZN 2 @ $1812 = $3624 ) and then used the Calendar view. From the view I could then download an iCal file to my Mac calendar with useful info for my stock purchases.
I’d really appreciate AirTable putting this feature for the Calendar View (select a field - rather than the default table 1st field) on their backlog of features.
