Skip to main content
Question

Variable drop down field

  • Oct 25, 2023 12:18 AM UTC
  • 0 replies
  • 82 views

Forum|alt.badge.img+8

Hello,

I have an interesting request. My QB app is pulling in entries and I am capturing the posting date of the entry / record. I can convert the posting date to a fiscal period such as Oct'23 using a formula field. I need the user to now select the fiscal period in which the entry will be reversed. I initially just created a static drop down field but received a request to make it variable so it only shows (in the drop down list) future fiscal periods. 

So if posting date is 10-01-2023...Fiscal period (Formula)= "Oct'23"

Drop down list should show:

Oct'23

Nov'23

Dec'23

Jan'24 etc

If posting date is 05-29-2023 and Fiscal period (Formula) is "Jun'23"

Drop down list should show:

May'23

Jun'23

Jul'23

Aug'23

Sep'23

Oct'23

Nov'23

Dec'23

Jan'24 etc

What's the best way to achieve this?

Thanks.

Deepa



------------------------------
Deepa Prashant
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+8

Correcting and clarifying my question above.

Using API's to create records in QB. 

I have an interesting request. My QB app is pulling in entries and I am capturing the posting date of the entry / record. I can convert the posting date to a fiscal period such as Oct'23 using a formula field. I need the user to now select the fiscal period in which the entry will be reversed. I initially just created a static drop down field but received a request to make it variable so it only shows (in the drop down list) future fiscal periods. 

So if posting date is 10-01-2023...Fiscal period (Formula)= "Oct'23"

Drop down list should show:

Oct'23

Nov'23

Dec'23

Jan'24 etc

If posting date is 05-29-2023 and Fiscal period (Formula) is "Jun'23" as May 29th is fiscal June in our company.

Drop down list should show:

Jun'23

Jul'23

Aug'23

Sep'23

Oct'23

Nov'23

Dec'23

Jan'24 etc

What's the best way to achieve this?

Thanks.

Deepa



------------------------------
Deepa Prashant
------------------------------