Discussions

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!

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

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

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

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

Is this possible to work only single button it means (Save & Close) button

Thanks Mark
 
is it possible

Without using java script it means only using quick base native  

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