I have form and two input fields as Start date and End date.i select two dates(01/05/2018 to 06/30/2018) and submit then ... | Discussions

Expand all | Collapse all

I have form and two input fields as Start date and End date.i select two dates(01/05/2018 to 06/30/2018) and submit then ...

  • 1.  I have form and two input fields as Start date and End date.i select two dates(01/05/2018 to 06/30/2018) and submit then ...

    Posted 04-05-2018 06:47
    I Am new to QuickBase, my requirement is , I have form and two input fileds as Start date and End date. When i select two dates(01/05/2018 to 06/30/2018) and submit form then create or insert records like 1)01-- 2018 -- 0.95(selected date not full month.if full month it treated as 1 see next record) 2) 02 -- 2018 -- 1 3) 03 --- 2018 -- 1 4) 04 --- 2018 ---1 5) 05 --- 2018 --- 1 6) 06 --- 2018 -1 insert records like these way, please explain as step by step because as i am new to Quick Base, Please response as soon as possible and Thanks Advance for solutions!


  • 2.  RE: I have form and two input fields as Start date and End date.i select two dates(01/05/2018 to 06/30/2018) and submit then ...

    Silver
    Contributor
    Posted 04-05-2018 06:52
    Hi Raghav,

    Welcome to the Quick Base Community.

    Can you please give me more details on the below part?

    >>>then create or insert records like 1)01-- 2018 -- 0.95(selected date not full month.if full month it treated as 1 see next record) 2) 02 -- 2018 -- 1 3) 03 --- 2018 -- 1 4) 04 --- 2018 ---1 5) 05 --- 2018 --- 1 6) 06 --- 2018 -1 insert records like these way

    Thanks,

    Gaurav Sharma


  • 3.  RE: I have form and two input fields as Start date and End date.i select two dates(01/05/2018 to 06/30/2018) and submit then ...

    Posted 04-05-2018 07:21
    I am explaing step by step
    1) I Created Parent Tables as "Projects" And "ChildRep"
    2) In Projects Table I have Created Two Fields as "Start Date" And "End Date"
    3) In ChildRep Table I Have Created Three Fields As "Per_Count" And "Per_Month" And "Per_year"
    3) In Projects When click On New Project Button As show Form As look like "Start Date" And "End Date"
    4) When i Select Two dates (01/05/2018 to 06/30/2018)  and click save close 

    Insert Records Like Below

    Projects Table

     RecordId     Start Date        End Date
        1                  01/05/2018       06/30/2018


    (Note: Established Relation from Projects to ChildRep As "one to many Relations")

    (Note:  when selected date ranges  as 01/05/2018 and 06/30/2018 and listed like below
    1 -> 01/05/2018 its not a full month it means (01/01/2018 to 01/31/2018 as a full month) but it selected from          01/05/2018 so we missed 5 days so we treated as full month so we putting 0.95 in  Per_Count  field in childrep table (full month treated as "1")

    2 - >02/01/2018 as full month "1"

    3 -> 03/01/2018  as full month "1"

    4 - >04/01/2018 as full month "1"

    5 - >05/01/2018 as full month "1"


    6 - >06/01/2018 to 06/30/2018 (When i selected end date(06/30/2018) as satisfied  to month ) as full month "1"


    )
    I want to this Out Put 


    ChildRep

    RecordId     ProjectRecordId    Per_Count     Per_Month   Per_year

      1                            1                              0.95                     01                     2018
      2                             1                               1                         02                     2018
      3                             1                                1                         03                    2018
      4                             1                                1                         04                    2018
      5                             1                                1                          05                   2018
      6                             1                                1                           06                   2018    
      
        
    Thanks


  • 4.  RE: I have form and two input fields as Start date and End date.i select two dates(01/05/2018 to 06/30/2018) and submit then ...

    Top
    Contributor
    Posted 04-05-2018 11:13
    This can done with script. The one issue I have is that for the first partial month you use a [Per Count] value of 0.95 when I would calculate it as 27/31 = 0.87 since the start date if four days after the start of the month.

    In any event, the following demo creates a set of child records equally spaced in time (days, weeks, months, quarters, years) based on a button click and user inputs. It can easily be modified to initialize the fields you describe.

    The explanation in the forum might be a bit difficult to understand as it used some technical terms from functional programming but I was just trying to demonstrate how the task of creating and initializing child records can be automated and implemented in a very general fashion. You may have to study the example a little and create your own records but the example is general enough to give you the behavior you need.

    Hylo[morphism] Technique
    https://haversineconsulting.quickbase.com/db/bkw2ff3c8

    Pastie Database
    https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=511


  • 5.  RE: I have form and two input fields as Start date and End date.i select two dates(01/05/2018 to 06/30/2018) and submit then ...

    Top
    Contributor
    Posted 04-05-2018 11:13
    This can done with script. The one issue I have is that for the first partial month you use a [Per Count] value of 0.95 when I would calculate it as 27/31 = 0.87 since the start date if four days after the start of the month.

    In any event, the following demo creates a set of child records equally spaced in time (days, weeks, months, quarters, years) based on a button click and user inputs. It can easily be modified to initialize the fields you describe.

    The explanation in the forum might be a bit difficult to understand as it used some technical terms from functional programming but I was just trying to demonstrate how the task of creating and initializing child records can be automated and implemented in a very general fashion. You may have to study the example a little and create your own records but the example is general enough to give you the behavior you need.

    Hylo[morphism] Technique
    https://haversineconsulting.quickbase.com/db/bkw2ff3c8

    Pastie Database
    https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=511


  • 6.  RE: I have form and two input fields as Start date and End date.i select two dates(01/05/2018 to 06/30/2018) and submit then ...

    Posted 04-10-2018 07:29
    Is this possible to work only single button it means (Save & Close) button


  • 7.  RE: I have form and two input fields as Start date and End date.i select two dates(01/05/2018 to 06/30/2018) and submit then ...

    Posted 04-06-2018 04:30
    Thanks Mark
     
    is it possible

    Without using java script it means only using quick base native  


  • 8.  RE: I have form and two input fields as Start date and End date.i select two dates(01/05/2018 to 06/30/2018) and submit then ...

    Posted 04-06-2018 04:33
    If it not possible can give logic of javascript code for above requirement . it may help us soo much.

    Thanks for Advance who will provide logic