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

Question

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!

gauravsharma3 · Answer

Hi Raghav,Welcome to the Quick Base Community.Can you please give me more details on the below part?&gt;&gt;&gt;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 wayThanks,Gaurav Sharma

raghavreddy · Answer

I am explaing step by step1) 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&nbsp;(01/05/2018 to 06/30/2018)&nbsp; and click save close&nbsp;Insert Records Like BelowProjects Table&nbsp;RecordId&nbsp; &nbsp; &nbsp;Start Date&nbsp; &nbsp; &nbsp; &nbsp; End Date&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/05/2018&nbsp; &nbsp; &nbsp; &nbsp;06/30/2018(Note: Established Relation from Projects to ChildRep As "one to many Relations")(Note:&nbsp; when selected date ranges&nbsp; as 01/05/2018 and 06/30/2018 and listed like below1 -&gt; 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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/05/2018 so we missed 5 days so we treated as full month so we putting 0.95 in&nbsp;&nbsp;Per_Count&nbsp; field in childrep table&nbsp;(full month treated as "1")2 - &gt;02/01/2018 as full month "1"3 -&gt; 03/01/2018&nbsp; as full month "1"4 - &gt;04/01/2018 as full month "1"5 - &gt;05/01/2018 as full month "1"6 - &gt;06/01/2018 to 06/30/2018 (When i selected end date(06/30/2018) as satisfied&nbsp; to month&nbsp;) as full month "1")I want to this Out Put&nbsp;ChildRepRecordId&nbsp; &nbsp; &nbsp;ProjectRecordId&nbsp;&nbsp;&nbsp; Per_Count&nbsp; &nbsp; &nbsp;Per_Month&nbsp; &nbsp;Per_year&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.95&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018&nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018&nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;04&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2018&nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018&nbsp; 6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2018&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;Thanks

_anomdiebolt_ · Answer

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

_anomdiebolt_ · Answer

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

raghavreddy · Answer

Thanks Mark&nbsp;is it possibleWithout using java script it means only using quick base native&nbsp;&nbsp;

Forum Discussion

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

7 Replies

Related Content

Snapshot Fields

Find and Replace Field Values

Proxy fields

Consolidate Field Types

Bulk upsert field limit in pipeline