Air table Base Your University, Large Public University (LPU), has a local chapter of the ATLAS (Association for Technology Literacy and Service) student organization. The organization sponsors a number of social events, service projects, and guest speakers to help students to develop technology skills and social connections with students across campus. Sasha Harrison, the club president, has recently started using an Air table base to help with the management of the club’s events, membership, and budget. You have volunteered to help him complete the base. The base has (or will once you have finished your work) the following tables: Member: Contains information about each of the club members. Event: Stores information about the various events of the club. Notice that the default way to view the table is as a calendar of events. The event table is connected to the Member table to facilitate tracking which members attend each event. Budget: Stores information that links the expense items to events. Expense: Used to track the expenses incurred by the club for each event. It is connected to the Event Budget table to allow expenses to be associated with the events for which they are incurred. Major: Stores a list of all of the degree majors on campus with the department and college associated with each. Income: Stores information about amounts and sources of income for the club. This table is not yet implemented in the base. You will help Sasha to add the table. Income is linked to the Member table so that income items can be associated with members who helped to generate the income. Complete the following activities to help Sasha to finish the base in Air table. Create a personal account with Air table. You can create an account by navigating to https://airtable.com/signup. Copy your Air table ID (API Key) into cellC4. key8M3nL4eaXfhwQ0 Your API Key can be found at https://airtable.com/account Create a copy of the Student Organization Base where you can complete your word Open the ATLAS Student Organization base template in Air table (using this link). Click on “Copy Base” to create a copy of the base so that you complete the tasks in this assignment. Copy your Base ID into cellC5. The Base ID can be found by selecting the base you just created at https://airtable.com/api. Once you have copied the base, open your copy of the base to complete the remaining tasks in this assignment. Record the attendance for the April officers’ meeting. In the Event table, update the “Officers meeting – April” record to link the to the following member records: Sasha Harrison Phillip Cullen Annabella Warren Elijah Allen Create a form to add new members to the Member table. ‘Create a form view of the member table. Name the form “New Member Form”. Add the description “Use this form to add new members”. The form should include the following fields: FirstName LastName Email Position t_shirt_size Phone Zip Major name Share the form and copy the link to your form into cell C10.’Use the form you just created to add the following new members. Fields and values for the first new member: firstName: Brent lastName: Thomason email: [email protected]: Member (select from the drop-down list)t_shirt_size: Large (select from the drop-down list.)phone: 8013442203 zip: 84003 major_name: Business Education (select the major from the list of majors.) Leave the photo, event_id, expense_id, or income_id fields blank if they are part of the form. Fields and values for the second new member:first_name: Christo last_name: Nielson email: [email protected] Position: Member t_shirt_size: X-Large phone: 7019321903 zip: 58102 major_name: Computer Engineering Leave the photo, event_id, expensed, or income_id fields blank if they are part of the form. Fields and values for the third new member: firstName: Angela lastName: Sanders email: [email protected]: Membert_shirt_size: Mediumphone: 6519284507zip: 55108 major_name: BusinessLeave the photo, event_id, expense_id, or income_id fields blank if they are part of the form.Create a new table named “Income” (without the quotes) with the following fields: · income_id: This will be the field used to connect the income table with other tables in the base. It will be an auto-generated field that will be the combination of the amount and member_id fields. Since the source and member_id fields are not yet created, you will complete this column last. Add the income data to the Income table. 1. Copy and paste the income data (rangeC3:G35) from the IncomeData worksheet of this spreadsheet file. 2. Do not copy and paste the header row of the data (amount, date_received, source, member_id, and notes). 3. Also, do not copy the values for income_id in column B since these will be automatically populated in Airtable. Update the Income table to reflect that the new members have paid their dues. 1. The new members you added in task 5 have all paid their dues. 2. Update the income table by adding new income rows for Brent, Christof, and Angela that record that they have paid $50 in dues each. 3. Use today’s date as the value for date_received for these entries. · date_received: This is the date that the income was paid to the club. Set the field as the date data type using the local date format. · amount: This will store the dollar amount of each new income entry on the table. Set this field as the currency data type with a precision of two decimals to the right of the decimal place. · source: This will be used to identify where each income entry comes from. Set this field as the single select data type with the four sources of income for the club (Dues, Fundraising, School Appropriation, and Sponsorship) as the options. This will force the user to select from the four valid sources of income for the club when adding a new income row to the table. · member_id: This will be used to connect an income entry with the member responsible for generating the income. Set this field to link to another record. Select the Member table as the table for this field to link to. Allow the field to link to multiple members. This will allow the user to select which member or members to associate with a new income row in the table. · notes: This will be used by the user to provide any explanations or comments about an income entry. Set this field as the long text data type. · Complete the income_id field. Set this field with the formula data type. The formula you will use for this field is: source & ‘: ‘ & member_id. This formula will display the value of the source field, a colon with a space ‘: ‘ and the value for the member field for each row of the table. The & character tells Airtable to combine the elements of the formula. · · · Connect to Airtable 4. 5 API Key Base ID 7 Member Form 9 10 URL 12 13 14 15 16 17 18 19 2″ style=’width:24.3pt;height:24.3pt;visibility:visible;mso-wrap-style:square; mso-left-percent:-10001;mso-top-percent:-10001;mso-position-horizontal:absolute; mso-position-horizontal-relative:char;mso-position-vertical:absolute; mso-position-vertical-relative:line;mso-left-percent:-10001;mso-top-percent:-10001; v-text-anchor:top’ o:gfxdata=”UEsDBBQABgAIAAAAIQC2gziS/gAAAOEBAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbJSRQU7DMBBF 90jcwfIWJU67QAgl6YK0S0CoHGBkTxKLZGx5TGhvj5O2G0SRWNoz/78nu9wcxkFMGNg6quQqL6RA 0s5Y6ir5vt9lD1JwBDIwOMJKHpHlpr69KfdHjyxSmriSfYz+USnWPY7AufNIadK6MEJMx9ApD/oD OlTrorhX2lFEilmcO2RdNtjC5xDF9pCuTyYBB5bi6bQ4syoJ3g9WQ0ymaiLzg5KdCXlKLjvcW893 SUOqXwnz5DrgnHtJTxOsQfEKIT7DmDSUCaxw7Rqn8787ZsmRM9e2VmPeBN4uqYvTtW7jvijg9N/y JsXecLq0q+WD6m8AAAD//wMAUEsDBBQABgAIAAAAIQA4/SH/1gAAAJQBAAALAAAAX3JlbHMvLnJl bHOkkMFqwzAMhu+DvYPRfXGawxijTi+j0GvpHsDYimMaW0Yy2fr2M4PBMnrbUb/Q94l/f/hMi1qR JVI2sOt6UJgd+ZiDgffL8ekFlFSbvV0oo4EbChzGx4f9GRdb25HMsYhqlCwG5lrLq9biZkxWOiqY 22YiTra2kYMu1l1tQD30/bPm3wwYN0x18gb45AdQl1tp5j/sFB2T0FQ7R0nTNEV3j6o9feQzro1i OWA14Fm+Q8a1a8+Bvu/d/dMb2JY5uiPbhG/ktn4cqGU/er3pcvwCAAD//wMAUEsDBBQABgAIAAAA IQC8PO0iGQMAAEQGAAAOAAAAZHJzL2Uyb0RvYy54bWysVE1v4zYQvRfofxjw0JsiUZE/pEZZOJa1 COpsg93uD6AlyiIqkSrJRM4W/e8dUrbjZC9FWx0EcoZ8M2/mcW4+HPoOnrk2Qsmc0KuIAJeVqoXc 5+Trb2WwJGAskzXrlOQ5eeGGfLj98Yebcch4rFrV1VwDgkiTjUNOWmuHLAxN1fKemSs1cInORume WdzqfVhrNiJ634VxFM3DUel60KrixqC1mJzk1uM3Da/sr01juIUuJ5ib9X/t/zv3D29vWLbXbGhF dUyD/YsseiYkBj1DFcwyeNLiO6heVFoZ1dirSvWhahpRcc8B2dDoHZsvLRu454LFMcO5TOb/g60+ PT9qEHVOrucLApL12KTPWDYm9x0Hb6y5qbBkKwrNAVZwBwVsoISPcA+/wBYe4BNEQCGGn/b2Z1gr KfE+WAUroS3bIUxyBTNYPeJ5/gJ3zHC4L2ABD7zfYfdL7C6kQCP4+nkLNAZ6DTQBOgM6B7oAugSa Qux6NQ4mw5S/DI/aVdsMW1X9bkCqdYsJ85UZMDTqEJmcTFqrseWsxqJRBxG+wXAbg2iwGx9UjdzZ k1W+k4dG9y4G9ggOXjAvZ8Hwg4UKjdfRck5RVhW6jmsXgWWny4M29iNXPbhFTjRm58HZ89bY6ejp iIslVSm6Du0s6+QbA2JOFgyNV53PJeEl9mcapZvlZpkESTzfBElUFMGqXCfBvKSLWXFdrNcF/cvF pUnWirrm0oU5yZ0m/0xOx4c3CfUseKM6UTs4l5LR+9260/DM8LmV/vMlR8/rsfBtGr5eyOUdJRon 0V2cBuV8uQiSMpkF6SJaBhFN79J5lKRJUb6ltBWS/3dKMOYkncUz36WLpN9xi/z3PTeW9cKipDvR 52R5PsQyp8CNrH1rLRPdtL4ohUv/tRTY7lOjvV6dRCf171T9gnLVCuWEysPRi4tW6W8ERhxjOTF/ PDHNCXT3EiWf0iRxc89vktkixo2+9OwuPUxWCJUTS2Baru00K58GLfYtRqK+MFKt8Jk0wkvYPaEp q+PjwlHlmRzHqpuFl3t/6nX43/4NAAD//wMAUEsDBBQABgAIAAAAIQCY9mwN2QAAAAMBAAAPAAAA ZHJzL2Rvd25yZXYueG1sTI9BS8NAEIXvgv9hGcGL2I0ipcRsihTEIkIx1Z6n2TEJZmfT7DaJ/97R HvQyj+EN732TLSfXqoH60Hg2cDNLQBGX3jZcGXjbPl4vQIWIbLH1TAa+KMAyPz/LMLV+5Fcailgp CeGQooE6xi7VOpQ1OQwz3xGL9+F7h1HWvtK2x1HCXatvk2SuHTYsDTV2tKqp/CyOzsBYbobd9uVJ b652a8+H9WFVvD8bc3kxPdyDijTFv2P4wRd0yIVp749sg2oNyCPxd4p3t5iD2p9U55n+z55/AwAA //8DAFBLAQItABQABgAIAAAAIQC2gziS/gAAAOEBAAATAAAAAAAAAAAAAAAAAAAAAABbQ29udGVu dF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhADj9If/WAAAAlAEAAAsAAAAAAAAAAAAAAAAALwEA AF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhALw87SIZAwAARAYAAA4AAAAAAAAAAAAAAAAALgIA AGRycy9lMm9Eb2MueG1sUEsBAi0AFAAGAAgAAAAhAJj2bA3ZAAAAAwEAAA8AAAAAAAAAAAAAAAAA cwUAAGRycy9kb3ducmV2LnhtbFBLBQYAAAAABAAEAPMAAAB5BgAAAAA= ” filled=”f” stroked=”f”>
AssignmentTutorOnline
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
