Filter on quarter time period in an input field

Question

Hello, I have created a quarter time field on a ux page. I can select all quarters in that field. I now want to be able to only select the Q2 and Q4 quarters for that input field on the ux page. How? Thanks! Kind regards!

Kanishq17 · Answer

Hello @filipsneyers

You can do two ways ,

One , create a filter for the time period to show in another system module and mark Q2,Q4 , then in UX page apply that filter to show only relevant time period to chose from

Alternately , you can create a DCA for write based on boolean check and apply DCA on the target module (which is input for UX) , so it will mark Q1 , Q3 as read only and Q2 , Q4 to write

Thanks

Kanishq

asarna · Answer

Hey @filipsneyers ,

I guess you're looking something similar (attached picture) - if yes, then create a SYS module and formula for filtering the quarters, that's it!!

NOTE: Q2 and Q4 are visible by filters and not by Show/Hide in NUX page.

filipsneyers · Answer

ok, thanks, that last option, I don not entirely understand. Can you explain in detail? I have created a line item "only Q2 et Q4" as a boolean : IF LEFT(NAME(ITEM(Time)), 2) = "Q2" OR LEFT(NAME(ITEM(Time)), 2) = "Q4" THEN TRUE ELSE FALSE but this is a boolean and i want a list line item with this filter