adspmo
asked on
Creating a form when another form is saved or......??Another way..
Hi All
I have a form that is going to be used for tracking the WhereAbouts of the person who creates it.
This has to be shown on a calendar.
On the Original form there are 4 pairs of Calendar fields
The field are name StartDate:EndDate:StartDat e_1:EndDat e_1...etc. ..
They will be used to track where a person will be within the Date range.
Part of the requirement is thta if the fields are not empty they will show up on a calendar view.
I was thinking it is probably easiest to when the original fom is saved that a script create an new form, One for each date range that is not Blank.
If there is another way to do this I would love to know. They have to show up on a calendar if the date ranges are not empty.
ANy help appreciated\
James
I have a form that is going to be used for tracking the WhereAbouts of the person who creates it.
This has to be shown on a calendar.
On the Original form there are 4 pairs of Calendar fields
The field are name StartDate:EndDate:StartDat
They will be used to track where a person will be within the Date range.
Part of the requirement is thta if the fields are not empty they will show up on a calendar view.
I was thinking it is probably easiest to when the original fom is saved that a script create an new form, One for each date range that is not Blank.
If there is another way to do this I would love to know. They have to show up on a calendar if the date ranges are not empty.
ANy help appreciated\
James
ASKER
Use the list where? In the column in a view?
@TRim(StartDate : EndDate:StartDate_1:EndDat e_1etc.... .???
@TRim(StartDate : EndDate:StartDate_1:EndDat
In Column
@Trim(@Explode( @TextToTime(@Text(StartDat e) + "-" + @Text(EndDate)) : @Explode( @TextToTime(@Text(StartDat e_1) + "-" + @Text(EndDate_1)) )
@Trim(@Explode( @TextToTime(@Text(StartDat
ASKER
I am using the same view to show calendar events from multiple forms
The following only shows only the info from the first form
@If(Form = "leave_fm";NoShowHolidaysW kEnds;Form = "lsf";@Trim(@Explode( @TextToTime(@Text(StartDat e_1) + "-" + @Text(EndDate_1)) : @Explode( @TextToTime(@Text(StartDat e_2) + "-" + @Text(EndDate_2)) ) ));"")
The selection formula is as follows
SELECT ((Form = "leave_fm": "LSF") & Approvalstatus="Approved") |(Form="Ev ent")
The following only shows only the info from the first form
@If(Form = "leave_fm";NoShowHolidaysW
The selection formula is as follows
SELECT ((Form = "leave_fm": "LSF") & Approvalstatus="Approved")
You have to enable column property (2nd tab) "Show Multiple values as seperate entries"
ASKER
I can see the documents in the view when in designer, When I look at the calendar the documents are not showing up
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As I recall, if you turn on the "multiple values as separate rows" option for more than one column, Notes will try to "match up" corresponding multiple values.
So, if I have two fields:
StartDate: 1/1,2/2,3/3
Comment: Jan,Feb,Mar
And I make a column for startDate, a second column for Comment, and make both columns show multiple values as separate rows, this would be the result:
Row A: 1/1 + Jan
Row B: 2/2 + Feb
Row C: 3/3 + Mar
Check that out by making your vew a regular view, not a calendar view. If it works as a regular view, you can turn it back into a calendar view, and see if things still match up correctly.
So, if I have two fields:
StartDate: 1/1,2/2,3/3
Comment: Jan,Feb,Mar
And I make a column for startDate, a second column for Comment, and make both columns show multiple values as separate rows, this would be the result:
Row A: 1/1 + Jan
Row B: 2/2 + Feb
Row C: 3/3 + Mar
Check that out by making your vew a regular view, not a calendar view. If it works as a regular view, you can turn it back into a calendar view, and see if things still match up correctly.
What did you have to do to fix this?
~Hemanth