Multiselect options for to tag statement from goog...

Mathews_Wakhung · 12-11-2020 06:44 PM

I am looking to create multiselect options to code/ tag about 1000 review statements in a google sheet column. I would like someone to be able to select more than one tag from 3-5 options in category A, B, C, and or D. Ideally, the list options will be entered in a google sheet.

Data structure

Column A :timestamp

Column B: statements (text)

For each statement, I would like to select one or multiple tags from or more columns (Themes) containing tags.

Column C: multiselect drop down list with text tags for Theme 1 later be becoming comma separated after tags

Column 😧 multiselect drop down list with text tags for Theme 2 later be becoming comma separated after tags

Column E:multiselect drop down list with tags for Theme 2 later be becoming comma separated after tags

Column F: multiselect drop down list with text tags for Theme 3 later be becoming comma separated after tags

Column G: single select drop down list with 4 tags.

Analysis: After tagging I would like like calculate the frequency of tag/code applications as per total statements. Any ideas?

Bellave_Jayaram

It isn’t clear as to what you want to achieve. What data is the user looking at to choose the tags and what happens after tagging?

Mathews_Wakhung

Sorry it was not clear. Just edited the question.

LeventK

How is your sheet structured? What are the date types? How that tags need to be selected? etc.etc. Please give major details so that we may offer some “how-to” guidance.

Mathews_Wakhung

Updated the question. Hope it’s much clearer

LeventK

How do you want to perform that frequecy calculation? As per which criteria?

Mathews_Wakhung

Frequency of tag as per total statements

LeventK

Please exemplify. Cannot get what you are trying to do.

Mathews_Wakhung

Mathews_Wakhung

**

Mathews_Wakhung

LeventK

I do apologize but I have understood totally nothing from what you are trying to achieve . Basically do you want to count the number of occurences of each list item in Sheet1 from the results table? *i.e. total number of “story”, total number of “duration”, total number of “guest”, total number of “relatability” in [Content Design] column and similarly for the rest of the columns? Is that what you want to achieve as a result?

Mathews_Wakhung

So sorry! I would like to send users the statements, they will use the lists to tag the ideas or themes in the statement. Basically, qualitative analysis. In the examples, a user my interpret the statement to be talking about a story, or language, or character so they would tap/select the items on the shown on my the list. The selection will recorded in the sheet in th back end.i have already figured out the analysis part. I really interested in creating an app that can help users select options based on the statements.

Mathews_Wakhung

Yes, that’s what I would like for the results

LeventK

So for each list item in Sheet1 you need to construct a Virtual Column with a COUNT expression:

COUNT(
    SELECT(
        ResultsTable[KeyColumn],
        CONTAINS("Story",[Content Design]
    )
)

In total you need to construct 27 Virtual Columns. Bear in mind that this amount of VC, will increase your app’s sync time.

Mathews_Wakhung

Thank you for the suggestion. My biggest challenge is how I can construct an interface like this that gets data from google sheets. I already have the analysis sorted.

LeventK

You can’t get exacty this unfortunately. But the closest could be having an ENUMLIST field for each section/cateogry with text base and displayed as stack. Then assign a Detail View for this table, make slideshow mode ON and assign the section/category columns as QUICK EDIT fields.

Check the afore-mentioned concept with clicking on your username in the deck menu of my community sample app.

Steve

A “multiselect drop down list with text tags” is called an EnumList in AppSheet.

Have you tried creating an app yet?

Multiselect options for to tag statement from google sheets