politics-rewired / Spoke

Politics Rewired's fork of Spoke
GNU General Public License v3.0
34 stars 16 forks source link

Allow multiple cells in contact CSV upload #1652

Open kohlkenn opened 11 months ago

kohlkenn commented 11 months ago

Is your feature request related to a problem? Please describe. Data acquired for texting often includes multiple columns of possible cells. Admins could be saved extra data management and see better targeting if they were able to identify and prioritize which columns should be assessed as possible cells.

Describe the solution you'd like When mapping arbitrary CSVs to Spoke-required columns upon contact upload: Admins should be able to specify up to three columns as possible cells, in order of priority. Spoke should require that at least one column be identified as Cell: Priority 1 and additionally allow Cell: Priority 2 and Cell: Priority 3.

When validating cells, Spoke should do the following:

Screenshot 2023-08-02 at 5 32 26 PM

Describe alternatives you've considered Admins can create distinct rows for every combination of contact+cell and risk double-texting individuals with multiple valid provided cells

Admins can identify the highest priority / most likely column as cell and lose out on validating lower certainty cells if the prioritized cell is invalid.