# Sometimes it works?

**URL:** <https://community.glideapps.com/t/sometimes-it-works/39045>\
**Category:** Ask for Help\
**Created:** [February 27, 2022, 10:13pm UTC](https://community.glideapps.com/t/sometimes-it-works/39045 "2022-02-27T22:13:12Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![shukong](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shukong/32/37208_2.png) [@shukong](https://community.glideapps.com/u/shukong)\
**Post date:** [February 27, 2022, 10:13pm UTC](https://community.glideapps.com/t/sometimes-it-works/39045/1 "2022-02-27T22:13:12Z")

</div>

Trying to create a candidate listing app for a local election.

> **[WinchesterVotes2022](https://winchestervotes2022.glideapp.io/)**
>
> This mobile app attempts to present candidate information for the March 19, 2022 annual town wide election for many open offices and for Town Meeting.

The idea is, there is a tab (bottom center) that shows all candidates in the order they appear on the ballot. Then in the menu (hamburger top left) you should find the offices (e.g. select board), see who’s running for those offices, and pick a name and go to the same “all candidates” listing.

Works for Vincent Lawrence Dixon, shows up correctly in “all candidates” tab, then in the menu under “select board” finding his name in the list, it goes to the full information as listed under “all candidates”. Menu → Precinct 1, select Vincent Lawrence Dixon and it also goes to the full description.

EDIT (2.28): single candidate lists workaround below; two-candidates still problematic…

Fail: In “all candidates” Patrick Gill shows up fine. In Precinct 1, also good. But Patrick is also running for Assessor, and if selecting from the Assessor in the menu, it goes to a Patrick Gill but NO DETAILS. I built these tables exactly the same, so I thought. Why do Patrick Gill and others (e.g. Karen Bolognese fine in All Candidates and School Committe works, but FAILS in Precinct 6 lookup ?

Missing something, probably obvious, but the inconsistent behavior is troublesome.

---

<div class="post-metadata">

**Author:** ![shukong](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shukong/32/37208_2.png) [@shukong](https://community.glideapps.com/u/shukong)\
**Post date:** [February 28, 2022, 3:26pm UTC](https://community.glideapps.com/t/sometimes-it-works/39045/2 "2022-02-28T15:26:00Z")

</div>

One-candidate menu selections I can fix by changing the detail screen to Details instead of List presentation. This works for Moderator and Assessor now. But for two-candidate posts sometimes it’s still not working – “Library Board of Trustee” has two candidates, and if I select “details” only the first one shows up… So one workaround for single-candidate does not work for the Library Board of Trustee office…

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 1, 2022, 3:01am UTC](https://community.glideapps.com/t/sometimes-it-works/39045/3 "2022-03-01T03:01:57Z")

</div>

It might help to see how your data tables are set up and if/how you have your relations configured to link the office to the candidate.

---

<div class="post-metadata">

**Author:** ![shukong](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shukong/32/37208_2.png) [@shukong](https://community.glideapps.com/u/shukong)\
**Post date:** [March 1, 2022, 4:10am UTC](https://community.glideapps.com/t/sometimes-it-works/39045/4 "2022-03-01T04:10:21Z")

</div>

What is a recommended way for me to show ? Can I add your email to the team?

---

<div class="post-metadata">

**Author:** ![shukong](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shukong/32/37208_2.png) [@shukong](https://community.glideapps.com/u/shukong)\
**Post date:** [March 1, 2022, 5:16am UTC](https://community.glideapps.com/t/sometimes-it-works/39045/5 "2022-03-01T05:16:48Z")

</div>

![AllCandidates](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/9/f9997eeaf5c55faf15ed46489605456a913769b2.jpeg)  
 ![LibraryBoard-FAIL](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b0b5e225f3378458155eee640b85d5ec5374552f.jpeg)  
 ![LibraryBoard-Relation](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/37fc5306ea0d667e71229e7264da6e235fab0e49.jpeg)  
 ![SelectBoard-OK](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a317985117459395aad9bb1b127e63dafbe00d63.jpeg)  
 ![SelectBoard-Relation](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f799492ac4d16e1e544abadcdade70ed10c4dbdd.jpeg)  
“All Candidates” is where all the data is posted  
“Select board” works as expected  
“Library board” only goes to a name, expecting to see the relation link to the original “all candidates” but noooo…  
“Library board-detail”.jpg shows that the reference LOOKS like it should show the correct detailed view, but dead ends in just a name.

Any other screenshots that might be helpful?

 ![LibraryBoard-Detail](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cd5ab4857089bc6a9c5c164794358caf738bc99d.jpeg)

---

<div class="post-metadata">

**Author:** ![shukong](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shukong/32/37208_2.png) [@shukong](https://community.glideapps.com/u/shukong)\
**Post date:** [March 2, 2022, 3:15am UTC](https://community.glideapps.com/t/sometimes-it-works/39045/6 "2022-03-02T03:15:18Z")

</div>

Looking at the details of the screen

 ![CandRel-RELATION-notTHISITEM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/dff852eba7e86abedde01b82c9e6da91e79445ce.jpeg)

The part that failed showed “THIS ITEM” rather than the Candidate Relation field.  
Now, when selecting Library Board of Trustee now that it is showing the Relation, leads to its Relation field in All Candidates.

This appears to be solved – need to dig into the details of the List showing on the screen.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 2, 2022, 3:16am UTC](https://community.glideapps.com/t/sometimes-it-works/39045/7 "2022-03-02T03:16:07Z")

</div>

I think the problem that you are running into is that you are viewing the candidate details from each individual table instead of the details from the All candidates table.

It seems like your data could be structured differently. Your ‘All Candidates’ table is fine. For the rest of your ‘Offices’ tables, I think you should have only a single row. That row should contain the Office only. No names. Then what you can do is create a multiple relation that links the Office column in each Office table to the Office column in the ‘All Candidates’ table. Then set up each Office tab with a details style layout. On each detail screen, add an inline list with the source of that list set to the relation. That way the list of candidates for that office will link directly to the all candidates table and when you click on a candidate, you will be viewing the details screen from that All Candidates table, which you already have set up.

---

<div class="post-metadata">

**Author:** ![shukong](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shukong/32/37208_2.png) [@shukong](https://community.glideapps.com/u/shukong)\
**Post date:** [March 2, 2022, 3:34am UTC](https://community.glideapps.com/t/sometimes-it-works/39045/8 "2022-03-02T03:34:55Z")

</div>

Thanks for your suggestion. The thing that threw me off was that even though Precinct 3 for example showed the relation field info, the detailed configuration was to show “this item” rather than the relation. So the app randomly would choose whether to show the relation or the item itself (which went to a dead end).

The links to details now work, so fingers crossed that this remains stable until the election is over… 🙂

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 3, 2022, 3:35am UTC](https://community.glideapps.com/t/sometimes-it-works/39045/9 "2022-03-03T03:35:28Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
