General Discussion

 View Only
  • 1.  Selecting data ranges from ProntoForms dropdown list or populating repetable section using MultiSelect Option

    Posted 02-21-2023 11:54

    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
    ------------------------------


  • 2.  RE: Selecting data ranges from ProntoForms dropdown list or populating repetable section using MultiSelect Option

    Staff
    Posted 02-21-2023 14:17

    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
    ------------------------------



  • 3.  RE: Selecting data ranges from ProntoForms dropdown list or populating repetable section using MultiSelect Option

    Posted 02-22-2023 05:27
    Edited by Karlygash Mukhitova 02-22-2023 07:24

    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. I am retrieving all data from the data sources

    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



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



  • 4.  RE: Selecting data ranges from ProntoForms dropdown list or populating repetable section using MultiSelect Option

    Adopter
    Posted 02-22-2023 07:03
    One option could be with a conditional, for example: if date text field is answered, set date text field from repeatable to date text field from non-repeatable section, else reset

    Kind regards

    Cesar McCoy
    KONE Inc. 





  • 5.  RE: Selecting data ranges from ProntoForms dropdown list or populating repetable section using MultiSelect Option

    Posted 02-22-2023 07:23

    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? 

    if date text field is answered, set date text field from repeatable to date text field from non-repeatable section, else reset --- In this case can I retrive data for the selected ranges?
    Thanks, 


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



  • 6.  RE: Selecting data ranges from ProntoForms dropdown list or populating repetable section using MultiSelect Option

    Adopter
    Posted 02-22-2023 08:15
    Sure, @Pat Cooney, can you please help us setting up a meeting?

    Cesar Mc Coy
    KONE Inc. 





  • 7.  RE: Selecting data ranges from ProntoForms dropdown list or populating repetable section using MultiSelect Option

    Posted 02-22-2023 08:29

    Thank you very much! I really appreciate your help 



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



  • 8.  RE: Selecting data ranges from ProntoForms dropdown list or populating repetable section using MultiSelect Option

    Staff
    Posted 02-22-2023 09:35

    @cesar mccoy I've sent you a private message about this :) 



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



Reminder: Content posted to our Community is public content.  Please be careful not to post Intellectual Property that you do not have permission to share.  For more information please refer to our Terms Of Use