I need to update 2 dates of my recurring record.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Hi I'm using the recurring function that is in this link: https://www.quickbase.com/db/9kaw8phg?a=dbpage&pagename=recurring.html. I think this is a quickbase development. This works very well for me but it only update 1 date. I'm using this for a calendar and it updates the starting date. I need to update not only the starting date but also the ending date. Is there a way to do this?

Thanks.

Photo of Alvaro Guerrero

Alvaro Guerrero

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Neal

Neal

  • 70 Points
Hi Alvaro,

I successfully created recurring tasks for start date and projected finish date in sample application "ABC Project Manager 4 in 1"

I followed the following steps :


  1. Created-Recurring-button to create field recurring for start-date
  2. Created-Recurring-button to create field recurring2 for projected-finish-date
  3. Made "recurring" field of Tasks available in list-view of Tasks(so that I can click on it)
  4. Clicked "recurring" link of one of the task record
  5. Selected yearly for 5 years
  6. it created 5 records with corresponding start-date and projected-finish-date as shown in the attachment

I disabled application token requirement while following above steps.



Let me know if you have any questions in reproducing this in your application.

Thanks,

Neal

NealPatil @ gmx.com



Photo of Alvaro Guerrero

Alvaro Guerrero

  • 0 Points
Hi Neal, Thanks for your answer. Where are these recurring buttons? I have downloaded your app and I dont see them,
Photo of Neal

Neal

  • 70 Points
Hi Alvaro,

I used App=Project Manager 4 in 1.It has Tasks .

Tasks has Start-date and projected-finish-date fields. I used these two fields for testing of creation of recurring tasks using your posted link  https://www.quickbase.com/db/9kaw8phg?a=dbpage&pagename=recurring.html.

You need to create two additional recurring fields in Tasks table using  https://www.quickbase.com/db/9kaw8phg?a=dbpage&pagename=recurring.html. The details about how I created those two fields is in the Steps I provided in my earlier answer.

You can also use your two date fields in your application instead of using Tasks of App=Project-Manager-4-in-1 .


Thanks,

Neal

NealPatil @  gmx.com
Photo of Neal

Neal

  • 70 Points
[mention://6685309 @Alvaro Guerrero]
Hi Alvaro, You need to create two recurring links/buttons using your posted link https://www.quickbase.com/db/9kaw8phg?a=dbpage&pagename=recurring.html - I just posted more details in answer section. Thanks, Neal - NealPatil @ gmx.com
Photo of Alvaro Guerrero

Alvaro Guerrero

  • 0 Points
Neal, thanks for your quick answer. I have created this 2 recurring links/buttons for my both fields (Starting Date and Ending Date). So, what should I do now? If I click 1 of them it only update me 1 field (Starting or Ending) not both.
Photo of Neal

Neal

  • 70 Points
[mention://6685309 @Alvaro Guerrero]
Hi Alvaro,
I created two buttons/links called "recurring" and "recurring2".
I clicked only one link/button called "recurring" and it created 5 records for 5 years because I chose yearly and max=5 times.
I did not find any need of clicking link/button=recurring2
Thanks,
Neal - NealPatil @ gmx.com
Photo of Alvaro Guerrero

Alvaro Guerrero

  • 0 Points
Hi Neal,
I did the same than you. The problem is if you click the first buttons/links called recurring (Asociated to Starting Date), it creates 5 new records where the Starting dates have changed but the Ending Dates (Asociated to recurring2) have not changed.
Photo of Neal

Neal

  • 70 Points
[mention://6685309 @Alvaro Guerrero]
Hi Alvaro,
I do not know if you have any special rules etc. in your existing table which might cause problems in  this creation of recurring records.

It is advisable to create one new table e.g. tasksTest having 3 fields - taskdescription, StartingDate and EndingDate(all 3 fields make it required)
Then create one record manually in tasksTest table.
Create two links/button for recurring task for StartingDate and EndingDate .
Then use one "recurring" link/button to create recurring tasks e.g. yearly frequency with max=5 records.
It should work in this new tasksTest table.
Meanwhile I will test above steps in my environment .

If recurring tasks are created successfully in this new table - then it is possible that configuration of your old table has something which causes problem  in creation of recurring tasks in old table.

Thanks,
Neal
NealPatil @ gmx.com
Photo of Neal

Neal

  • 70 Points
Hi Alvaro,

I created new TasksTest table as I mentioned in my comment with StartingDate and EndingDate

I created two recurring links/buttons for recurring-task for StartingDate and EndingDate

Clicked "Recurring" button and it successfully created 5 yearly recurring records for 5 years as shown in attachment.


Thanks,

Neal

NealPatil @ gmx.com
Photo of Neal

Neal

  • 70 Points
[mention://6685309 @Alvaro Guerrero]
Hi Alvaro,
I just tested it using new table TasksTest and it worked successfully.
I have attached screenshot in the answer section.
Thanks,
Neal
NealPatil @ gmx.com
Photo of Alvaro Guerrero

Alvaro Guerrero

  • 0 Points
Yes, I saw your screenshot and see that the ending date is always the same. That's the problem. It is not updating your ending date.
Photo of Neal

Neal

  • 70 Points
Hi Alvaro,

I found that clicking "Recurring2" link/button instead of "Recurring" link/button creates both recurring dates successfully .

In the following screenshot I clicked "Recurring2" link to create 5 recurring records for 5 years successfully.

So the trick is to click "Recurring2" link to create recurring records.

But problem is that Starting Date is not updating. Only Ending Date is updated with Recurring2.

I do not know the reason it worked in my first attempt(my first answer has screenshot).


Thanks,

Neal

NealPatil @ gmx.com

Photo of Neal

Neal

  • 70 Points
[mention://6685309 @Alvaro Guerrero]
Hi Alvaro,
I tried clicking Recurring2 link and it updated only EndingDate and not StartingDate.
So I do not know why it worked in my first test.
Thanks,
Neal
NealPatil @ gmx.com