949 & 505 fields creation in Airtable
- Melanie Shaw
Problem: Need to compose 505 and 949 data within Airtable to expedite inclusion in MARC record
Note : This solution is particular to the Serial Set by Congress Project setup in Airtable; future batchwork using these processes in Airtable will require similar preliminary setup)
949 Field Creation:
These are created at the item level.
Created a new field in Airtable base (Serial Set tab) and titled it MARC 949s
Select “Formula” for the field type
Used the following formula: CONCATENATE("949 ",{Call Number}," ǂi ",{Barcode}," ǂk - ǂl agloc ǂt 6")
Where the {Call Number} and {Barcode} are field names in Airtable.
This provided the following output with a 949 followed by two spaces, then the call number, followed by a space and subfield I, a space and then the barcode number, followed by a space, subfield K, space, dash, space, subfield l, space, agloc, space, subfield t, space, and 6. For example : 949 X 254 ǂi 39060020524319 ǂk - ǂl agloc ǂt 6
The 949 concatenated columns can then be copied all the way down & pasted into OCLC Connexion where each row will load as a separate 949 field.
505 Content Notes Field Creation:
These are first created at the item level and then rolled up together to create the content note for the whole Congress
Create a new field in the Airtable base (Serial Set base)
Select “Formula” for the field type
Used the following formula: CONCATENATE({Volume Number},". ",{Title}," (",{Date Range (from Imported table 2)},") -- ")
Where {Volume Number}, {Title}, and {Date Range (from Imported table 2)} are all field names in Airtable
This provided the following output with a period after the volume number, brackets around the date range, and ending with a double dash with a space on either side. For example: 1. Senate Journal, 15th Congress, 1st session (Mar 4, 1817 - Mar 3, 1819) –
Once this text has been created for each item, it needs to be “Rolled Up” for each Congress.
In the Congress details Tab, each congress has been listed and “linked” to the individual items in the Serial Set tab that correspond to that congress
Add a new field in the Congress Details tab
Select “Roll Up” as the field type
Set the parameters of the roll up field to:
Field on this table that links to the records you want to summarize: Imported table (this is the name of the field in Congress Details that links to the Serial Set tab).
Serial Set table field that you’d like to roll up: 505 Content Notes
Aggregation formula: Concatenate (values)
This will look like:
Once saved, it will roll up all the 505 Content Notes into one field
Note that the last item listed will need to have the ending double dash removed and a period put in it’s place.
Copy/paste the resulting rolled up content column text into OCLC as text into an empty 505 field.
