Help

Timelines: Time range with no specific dates

Topic Labels: Workflow Design
Solved
Jump to Solution
1564 2
cancel
Showing results for 
Search instead for 
Did you mean: 
dnieto
4 - Data Explorer
4 - Data Explorer

Hello!

I'm trying to organize a set of tasks that start from "two weeks ahead" of an event. Using fields such as duration or date will have me pick a specific date/time for which I don't have information. I just need those set of tasks to show "this lasts 2 weeks", or "prepare 1 week in advance" and I'm not sure how could I accomplish this using a timeline (I like the visuals that offer). 

Any ideas are appreciated! 

1 Solution

Accepted Solutions
Stephen_Orr1
10 - Mercury
10 - Mercury

Hi @dnieto,

It's a bit custom but you can achieve something like this with the help of few extra fields:

  • a linked record field - pointed at the same table to choose predecessor events
  • a lookup field - to display the start date of a predecessor event
  • a single-select dropdown - to hold date manipulation options like "as-is", "2 weeks later", "1 week earlier" etc.
  • a formula field - to add/subtract days from the predecessor event's start date based on the dropdown field's value

Then you could use this formula field as a start date in the timeline view and quickly adjust the relative date options via the single-select dropdown field all from within the same timeline view.

Also, you might take a look at the Gantt view for tracking dependent events. If you set up dependencies (a linked record field pointed to the same table it's in) in your Events table, then you can turn on dependencies in the Gantt view and drag the bounds of records to affect the dates of dependent events by date rippling.

Hope that helps!
-Stephen 

See Solution in Thread

2 Replies 2
Stephen_Orr1
10 - Mercury
10 - Mercury

Hi @dnieto,

It's a bit custom but you can achieve something like this with the help of few extra fields:

  • a linked record field - pointed at the same table to choose predecessor events
  • a lookup field - to display the start date of a predecessor event
  • a single-select dropdown - to hold date manipulation options like "as-is", "2 weeks later", "1 week earlier" etc.
  • a formula field - to add/subtract days from the predecessor event's start date based on the dropdown field's value

Then you could use this formula field as a start date in the timeline view and quickly adjust the relative date options via the single-select dropdown field all from within the same timeline view.

Also, you might take a look at the Gantt view for tracking dependent events. If you set up dependencies (a linked record field pointed to the same table it's in) in your Events table, then you can turn on dependencies in the Gantt view and drag the bounds of records to affect the dates of dependent events by date rippling.

Hope that helps!
-Stephen 

Hi, Stephen! 

That's something I can do! I'll try and see how it goes