nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey123 connect cascading sheets not working

JessicaRamirez1

Hi,

I'm having an issue getting my survey to work. I have 4 select_one questions, Division, Market, Portfolio, and then finally property. I can't seem to get past the portfolio part it has no options for me to choose. I need to be able to drill down to the property. I have attached my survey.

Form 1.xlsx

wangli1_0-1648898131945.png

Encontre mais publicações marcadas com

Accepted answers

dougbrowning

You can filter by more than one column. So something like this for Property

OffPortfolio=${OffPortfolio} and OffMarket=${OffMarket}

L_stanley1_0-1610639269071.png

All comments

JessicaRamirez1

Hi Doug,

I am filtering by division (for Office), then my filter by OffMarket to get city location, then filter by OffPortfolio to get the campus of office, then I want to select a property. No mater what I seem to do I can't get the properties to show up correctly off of the PropertyList. My example is selecting the office division, then select the Chicago market, then select office. Now if I select a Property I should only get 3 properties that show up. I only get the properties that have been filtered by division and by Portfolio, my market is not being used to filter for my property choices.

dougbrowning

I am not sure what you want to filter in the last question. By city or Office vs Campus. If Office v Campus it works for me.

JessicaRamirez1

Hi Doug,

Thanks for the reply. I added the OffMarket to the OffPortfolio, my sheet looks like this.

I can drill down to Select Portfolio now. However, all the choices for PropertyListOff shows up instead having these questions filter out for the ones I want.

dougbrowning

For the OffPortfolio list you are trying to use the OffMarket column but that column is blank for the OffPortfolio list.

You need to add the values like this

OffPortfolio

Campus

Office

Chicago

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.