Can we create multiple clild records on basis of date range?

Question

Hi Team,We have an application where we create blank time cards for associates in which they fill their hours per day for one year through import function.Can we do something that if we provide a start date and end date (Date range) then, with the help of button we can create the time cards?We want to trigger this button from the parent record.Please let me know if you require any additional information.Thanks,Gaurav

eric_j_hansen · Answer

This is definitely doable with a button that calls a fairly simple script on a code page hosted in your application.

Just to clarify, you will create a parent record and enter a start date and an end date, then click a button and it creates a child record for each day within that span? Including weekends?

Let me know if we are on the same page.

_anomdiebolt_ · Answer

See this demo:https://haversineconsulting.quickbase.com/db/bkw2ff3c8What is the Hylo Technique?https://community.quickbase.com/quickbase/topics/what-is-the-hylo-technique

gauravsharma3 · Answer

Yup, we are on the same page.Can you please explore about the script?Thanks in advance :)

gauravsharma3 · Answer

Hi Dan,I read it and it is very useful. I'll try to implement this and will get back to you if I miss something.Thanks for your help.Regards,Gaurav

gauravsharma3 · Answer

Hi Dan,I tried this and successfully implement the same.. Love your skills.There is a question when I create child records so, why it does not include the base date?Regards,Gaurav

Forum Discussion

Can we create multiple clild records on basis of date range?

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

create pipeline to create new records based on current record

Add button to create record in different app

Modify multiple rows within the same group using Single Record ?