search

OpenEugene / little-help-book-web

Human service resource guide powered by White Bird Clinic
MIT License
6 stars 4 forks source link

Clean up duplicate categories in provider table #113

Open markdav-is opened 4 years ago

markdav-is commented 4 years ago

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.

image

This also manifests in JSON returned by the API.

image

ArthurSmid commented 3 years ago

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 commented 3 years ago

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 Androidhttps://aka.ms/ghei36

From: ArthurSmid notifications@github.com Sent: Friday, November 13, 2020 1:54:55 PM To: OpenEugene/little-help-book-web little-help-book-web@noreply.github.com Cc: Mark Davis mark@markdav.com; Author author@noreply.github.com 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 GitHubhttps://github.com/OpenEugene/little-help-book-web/issues/113#issuecomment-727053909, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AACL6F4AGZQU57CMGOJ3YJLSPWTK7ANCNFSM4RT6PCPQ.