Icon

How to Update Individual Records in the 'ABOB Community from form submissions in the 'Update Your Details' base table

Learn a step-by-step process for updating individual records by transferring information from the 'Update Your Details' Airtable base to the ABAP Community, including filtering, editing, and marking updates as complete.

By Mike Crofton-Atkins

In this guide, we'll learn how to update individual records in the ABAP Community using information from the "Update Your Details" table in Airtable. This process involves finding the relevant update, copying the new information, and marking the update as complete. The goal is to ensure that records are accurate and up to date.

Let's get started

Okay. On the left side, we have the Update Your Details table, located in an Airtable base with the same name. Um, and there are ...

1
Click here
Step #1: Click here

There is an open list and a grid view. Refer to the open list. We have some updates here. Some of these came through a while ago and need to be completed.

2
Click here
Step #2: Click here

We'll start with the top one. We have an update from Jordan Hardy in Bristol. We expand that and see what he is updating.

3
Click on "Z"
Step #3: Click on "Z"

He is updating medications. On the right-hand side, go to the De-duplicate NQPT and MIT data view in ABAP Community.

4
Click here
Step #4: Click here

I click on Filter, add a condition, and set "name contains..."

5
Click here
Step #5: Click here
6
Click on "+ Add condition"
Step #6: Click on "+ Add condition"
7
Click on "Enter a value"
Step #7: Click on "Enter a value"

I type his name. There he is. Now I expand that.

8
Type "jordan hardy"
9
Click on "Apply"
Step #9: Click on "Apply"
10
Click on "✓"
Step #10: Click on "✓"

I am finding his medical information, replacing it with the information on the left-hand side, and pasting it into the right.

11
Click here
Step #11: Click here
12
Drag here
Step #12: Drag here
13
Type "Cmd + C"
14
Click on "I"
Step #14: Click on "I"
15
Click on "I"
Step #15: Click on "I"
16
Drag here
Step #16: Drag here
17
Type "Cmd + V"

He hasn't provided any other information, so that's what I'm updating. Now that I've done that, close the expanded view in Update Your Details. Then, scroll to the column labeled System Update Status, click the dropdown, and select Done.

18
Click here
Step #18: Click here
19
Click here
Step #19: Click here
20
Drag here
Step #20: Drag here
21
Click here
Step #21: Click here
22
Click here
Step #22: Click here
23
Click on "Done ( update completed )"
Step #23: Click on "Done ( update completed )"
24
Click on "Done ( update completed )"
Step #24: Click on "Done ( update completed )"

Here is a brief walkthrough of how you take updates from the Update Your Details base and table and apply them to the individual's record in ABAP Community.

25
Click here
Step #25: Click here