General Discussion

Hello dear Prontoforms users, 

I have question regarding date ranges

I would like to retrieve data by selecting the specific date range. For example, how to select data where date is more equal to chosen range(date<=2023-02-26)?

Thanks, 

Hi Karlygash,

Welcome to the Community! Thanks for your post here. If I understand this correctly you are looking to set a date range that includes today's date and then a second date?

I may not be understanding what you're trying to do so if you could provide a bit more information that would be great, thanks.

Pat

------------------------------
Pat Cooney
Community Engineer
ProntoForms
community@prontoforms.com

Original Message:
Sent: 02-21-2023 11:54
From: Karlygash Mukhitova
Subject: Selecting data ranges from ProntoForms dropdown list or populating repetable section using MultiSelect Option

Hello dear Prontoforms users, 

I have question regarding date ranges

I would like to retrieve data by selecting the specific date range. For example, how to select data where date is more equal to chosen range(date<=2023-02-26)?

Thanks, 

------------------------------
Karlygash Mukhitova
Data Engineer
Alcon
------------------------------

Hello @Pat Cooney 

Thanks for your reply 

Yes, I am looking for the solution where I can retrieve data regarding my selected options. 

Output from prontoforms 

Lets say, If I am using dropdown and chose 2023-02-01 (yyy-mm-dd) from the list I would like to get records to the repeatable section  as the following output

Output 

Date                                 Info

2023 - 02 - 01           Name 1

2023 - 02 - 02           Name 2

2023 - 02 - 03           Name 3

Where my data x >=2023 - 02 - 01, which includes chosen date [2023 - 02 - 01] and data which is greater than chosen date [2023 - 02 - 02,2023 - 02 - 03] these three days 

Or The second option is to use multi select tool and from the list to choose several days like in previous example [2023 - 02 - 01, 2023 - 02 - 02, 2023 - 02 - 03].  As an output to get records where date is equal for the selected options [2023 - 02 - 01, 2023 - 02 - 02, 2023 - 02 - 03]

Output 

Date                                 Info

2023 - 02 - 01           Name 1

2023 - 02 - 02           Name 2

2023 - 02 - 03           Name 3

Let me know if you have any questions and looking forward  to hearing from you

Hi Karlygash,

Welcome to the Community! Thanks for your post here. If I understand this correctly you are looking to set a date range that includes today's date and then a second date?

I may not be understanding what you're trying to do so if you could provide a bit more information that would be great, thanks.

Pat

Hello dear Prontoforms users, 

I have question regarding date ranges

I would like to retrieve data by selecting the specific date range. For example, how to select data where date is more equal to chosen range(date<=2023-02-26)?

Thanks, 

Hello @Pat Cooney 

Thanks for your reply 

Yes, I am looking for the solution where I can retrieve data regarding my selected options. 

Output from prontoforms 

Lets say, If I am using dropdown and chose 2023-02-01 (yyy-mm-dd) from the list I would like to get records to the repeatable section  as the following output

Output 

Date                                 Info

2023 - 02 - 01           Name 1

2023 - 02 - 02           Name 2

2023 - 02 - 03           Name 3

Where my data x >=2023 - 02 - 01, which includes chosen date [2023 - 02 - 01] and data which is greater than chosen date [2023 - 02 - 02,2023 - 02 - 03] these three days 

Or The second option is to use multi select tool and from the list to choose several days like in previous example [2023 - 02 - 01, 2023 - 02 - 02, 2023 - 02 - 03].  As an output to get records where date is equal for the selected options [2023 - 02 - 01, 2023 - 02 - 02, 2023 - 02 - 03]

Output 

Date                                 Info

2023 - 02 - 01           Name 1

2023 - 02 - 02           Name 2

2023 - 02 - 03           Name 3

Let me know if you have any questions and looking forward  to hearing from you

Hi Karlygash,

Welcome to the Community! Thanks for your post here. If I understand this correctly you are looking to set a date range that includes today's date and then a second date?

I may not be understanding what you're trying to do so if you could provide a bit more information that would be great, thanks.

Pat

Hello dear Prontoforms users, 

I have question regarding date ranges

I would like to retrieve data by selecting the specific date range. For example, how to select data where date is more equal to chosen range(date<=2023-02-26)?

Thanks, 

Hello @cesar mccoy 

Thanks for your reply

I did not quite follow your response. I am a very new user in prontoforms(((

Can you please expand your answer? 

Hello @Pat Cooney 

Thanks for your reply 

Yes, I am looking for the solution where I can retrieve data regarding my selected options. 

Output from prontoforms 

Lets say, If I am using dropdown and chose 2023-02-01 (yyy-mm-dd) from the list I would like to get records to the repeatable section  as the following output

Output 

Date                                 Info

2023 - 02 - 01           Name 1

2023 - 02 - 02           Name 2

2023 - 02 - 03           Name 3

Where my data x >=2023 - 02 - 01, which includes chosen date [2023 - 02 - 01] and data which is greater than chosen date [2023 - 02 - 02,2023 - 02 - 03] these three days 

Or The second option is to use multi select tool and from the list to choose several days like in previous example [2023 - 02 - 01, 2023 - 02 - 02, 2023 - 02 - 03].  As an output to get records where date is equal for the selected options [2023 - 02 - 01, 2023 - 02 - 02, 2023 - 02 - 03]

Output 

Date                                 Info

2023 - 02 - 01           Name 1

2023 - 02 - 02           Name 2

2023 - 02 - 03           Name 3

Let me know if you have any questions and looking forward  to hearing from you

Hi Karlygash,

Welcome to the Community! Thanks for your post here. If I understand this correctly you are looking to set a date range that includes today's date and then a second date?

I may not be understanding what you're trying to do so if you could provide a bit more information that would be great, thanks.

Pat

Hello dear Prontoforms users, 

I have question regarding date ranges

I would like to retrieve data by selecting the specific date range. For example, how to select data where date is more equal to chosen range(date<=2023-02-26)?

Thanks, 

Hello @cesar mccoy 

Thanks for your reply

I did not quite follow your response. I am a very new user in prontoforms(((

Can you please expand your answer? 

Hello @Pat Cooney 

Thanks for your reply 

Yes, I am looking for the solution where I can retrieve data regarding my selected options. 

Output from prontoforms 

Lets say, If I am using dropdown and chose 2023-02-01 (yyy-mm-dd) from the list I would like to get records to the repeatable section  as the following output

Output 

Date                                 Info

2023 - 02 - 01           Name 1

2023 - 02 - 02           Name 2

2023 - 02 - 03           Name 3

Where my data x >=2023 - 02 - 01, which includes chosen date [2023 - 02 - 01] and data which is greater than chosen date [2023 - 02 - 02,2023 - 02 - 03] these three days 

Or The second option is to use multi select tool and from the list to choose several days like in previous example [2023 - 02 - 01, 2023 - 02 - 02, 2023 - 02 - 03].  As an output to get records where date is equal for the selected options [2023 - 02 - 01, 2023 - 02 - 02, 2023 - 02 - 03]

Output 

Date                                 Info

2023 - 02 - 01           Name 1

2023 - 02 - 02           Name 2

2023 - 02 - 03           Name 3

Let me know if you have any questions and looking forward  to hearing from you

Hi Karlygash,

Welcome to the Community! Thanks for your post here. If I understand this correctly you are looking to set a date range that includes today's date and then a second date?

I may not be understanding what you're trying to do so if you could provide a bit more information that would be great, thanks.

Pat

Hello dear Prontoforms users, 

I have question regarding date ranges

I would like to retrieve data by selecting the specific date range. For example, how to select data where date is more equal to chosen range(date<=2023-02-26)?

Thanks, 

Hello @cesar mccoy 

Thanks for your reply

I did not quite follow your response. I am a very new user in prontoforms(((

Can you please expand your answer? 

Hello @Pat Cooney 

Thanks for your reply 

Yes, I am looking for the solution where I can retrieve data regarding my selected options. 

Output from prontoforms 

Lets say, If I am using dropdown and chose 2023-02-01 (yyy-mm-dd) from the list I would like to get records to the repeatable section  as the following output

Output 

Date                                 Info

2023 - 02 - 01           Name 1

2023 - 02 - 02           Name 2

2023 - 02 - 03           Name 3

Where my data x >=2023 - 02 - 01, which includes chosen date [2023 - 02 - 01] and data which is greater than chosen date [2023 - 02 - 02,2023 - 02 - 03] these three days 

Or The second option is to use multi select tool and from the list to choose several days like in previous example [2023 - 02 - 01, 2023 - 02 - 02, 2023 - 02 - 03].  As an output to get records where date is equal for the selected options [2023 - 02 - 01, 2023 - 02 - 02, 2023 - 02 - 03]

Output 

Date                                 Info

2023 - 02 - 01           Name 1

2023 - 02 - 02           Name 2

2023 - 02 - 03           Name 3

Let me know if you have any questions and looking forward  to hearing from you

Hi Karlygash,

Welcome to the Community! Thanks for your post here. If I understand this correctly you are looking to set a date range that includes today's date and then a second date?

I may not be understanding what you're trying to do so if you could provide a bit more information that would be great, thanks.

Pat

Hello dear Prontoforms users, 

I have question regarding date ranges

I would like to retrieve data by selecting the specific date range. For example, how to select data where date is more equal to chosen range(date<=2023-02-26)?

Thanks,