Clean up duplicate categories in provider table

[markdav-is]

providers that are mapped to two subcategories in the same category create duplicate categories in the provider table. I suspect this is because of relation going thru CatSubCat and not linking to the Category table directly.

This also manifests in JSON returned by the API.

[ArthurSmid]

To support volunteers who are helping to verify the data, I made use of an Airtable feature that allows us to hide columns. In the screen shot of the base, you'll see it in the menu bar "Hide fields".

Help Services is the only table needed for volunteers doing data maintenance, and by hiding fields they don't need to update in that table, it's possible for them to navigate with less confusion. This makes it much easier for volunteers to read and understand and update the contents of Help Services.

For the web team, if you need to view any of the hidden fields, you can toggle any of them into view by clicking on the Hide fields button and selecting the fields you want to access.

And yet, this doesn't solve the issue, about the JSON having duplicate category ids.

[markdav-is]

You might want to make a special view that has less columns. Im not sure how hiding columns will affect the API. Tables can have many views Sent from my T-Mobile 5G Device Get Outlook for Android<https://aka.ms/ghei36>

…

________________________________ From: ArthurSmid <[email protected]> Sent: Friday, November 13, 2020 1:54:55 PM To: OpenEugene/little-help-book-web <[email protected]> Cc: Mark Davis <[email protected]>; Author <[email protected]> Subject: Re: [OpenEugene/little-help-book-web] Clean up duplicate categories in provider table (#113) To support volunteers who are helping to verify the data, I made use of an Airtable feature that allows us to hide columns. In the screen shot of the base, you'll see it in the menu bar "Hide fields". Help Services is the only table needed for volunteers doing data maintenance, and by hiding fields they don't need to update in that table, it's possible for them to navigate with less confusion. This makes it much easier for volunteers to read and understand and update the contents of Help Services. For the web team, if you need to view any of the hidden fields, you can toggle any of them into view by clicking on the Hide fields button and selecting the fields you want to access. And yet, this doesn't solve the issue, about the JSON having duplicate category ids. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<#113 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AACL6F4AGZQU57CMGOJ3YJLSPWTK7ANCNFSM4RT6PCPQ>.