DropDown value

(0) Share

Report

Posted on by Sajarac

3,263

Hello, quick question:

I have a drop down list that is getting a values from my column customers, in my table I have several values and I would like to show in a textfield other value once the user select any customer, i.e.

Customer | Fiscal_Year

Customer A FY2016

Customer B FY2018

Customer C FY2017

or maybe is possible to show in the same dropdown box when the user select a customer beside the customer name the fiscal year?

Customer A FY2016

or maybe a search text box to show the customer and the Fiscal year?

what I am trying to do is search for a customer and get the Fiscal Year because my gallery is filtered by Fiscal Year based in a drop drown option, and I couldn't figure out any any way of add a "ALL FY" to show all of my customers. going mental

Thanks in advance

Regards

Categories:

General Questions

All responses (4)

Answers (1)

Sajarac 3,263 on at

Like (0)

Report

Re: DropDown value

Thank you very much!
Verified answer

Community Power Pla... on at

Like (0)

Report
Re: DropDown value

sajarac,

If you wanted info in "All FY", please add a row in your Assessments table (excel) and that particular row with "All FY" which sums up the other rows. Then you can change the item of the drop down to what you've had before: Assessments.FY

If you don't have a row All FY with any info, you could always hide the charts.
Without any data linked to All FY, you won't be able to extract data to the charts.

As for the second question, add the sortbycolumn to the previous solution,
SortByColumn((the first solution),"Assessment_Name",If(sortDescending1,Descending,Descending))

Regards

Dxiong
Sajarac 3,263 on at

Like (0)

Report

Re: DropDown value

Thank you very much for your preply, the formula works, fine, I just have a couple of questions:

1. I have two charts pie chart and a column chart linked with my dropdown box and it works fine, now with the new formula it only shows when I select an specific fiscal year not with "All FY"

And ther second question is I had my table sorted by fiscal year then by "Assessment_Name" Descending

as you can see in this formula:

is possible to sort the table with the new formula in the same way? this picture show the previous formula

Thanks in advance for your kind cooperation.

Regards
Community Power Pla... on at

Like (0)

Report
Re: DropDown value

Hi,

Let me see if I understand what your trying to say. You want to be able to filter your gallery based on Fiscal_Year and have an option to show all of the Fiscal _Year named "ALL FY"

Here's what I did:

Have the dropdown show your fiscal years.
["ALL FY",FY2016","FY2017","FY2018"]

Default: "ALL FY"

Then in the gallery, under Item:
If(DropDownFY.Selected.Value="ALL FY",Search( CustomerTable, Proper(searchBox1.Text), "Customer"), Filter( Search( CustomerTable, Proper(searchBox1.Text), "Customer"), DropDownFY.Selected.Value=Fiscal_Year))

After you fix the name of the table,dropdown and search box, the gallery should show up.

This should be right or at least close enough so you have an idea of what to do. I'm on my phone, so I have no way of checking right now.

Good luck