You are viewing limited content. For full access, please sign in.

Question

Question

Forms - how to get a row of data to display not separate columns....

asked on October 26, 2015

Laserfiche Forms 9.2.1

We're designing a form where staff can request time off. Besides selecting the date, they need to specify if they want a full or half day off. We are using a table because the employee can select between 1-10 days off. We want to send an email with the date (and full or half day). If more than one day is selected the email displays the information for each column rather than for each row.

 

Is this a limitation of forms or am I missing something?  Is this something that can be added for the next version?  

 

 

 

 

Example of Form Submission...

Email Task:

Date(s) of Requested Leave:  {/dataset/Table/Date} - {/dataset/Table/Full_Day_Half_Day}

 

(Output) Email Received:

Date(s) of Requested Leave:  10/24/2015; 11/14/2015; 10/22/2049 - Full Day; Half Day; Half Day


 

Desired Output:


Date(s) of Requested Leave: 10/24/2015 - Full Day; 11/14/2015 - Half Day; 10/22/2049 - Half Day;

OR

10/24/2015 - Full Day;

11/14/2015 - Half Day;

10/22/2049 - Half Day;

 

0 0

Answer

SELECTED ANSWER
replied on October 27, 2015 Show version history

Inserting a number next to "Table" will allow you to specify which value you want to populate: {/dataset/Table[1]/Date}. 

For example: Date(s) of Requested Leave: {/dataset/Table[1]/Date} - {/dataset/Table[1]/Full_Day_Half_Day}; {/dataset/Table[2]/Date} - {/dataset/Table[2]/Full_Day_Half_Day}; {/dataset/Table[3]/Date} - {/dataset/Table[3]/Full_Day_Half_Day}

1 0

Replies

replied on October 27, 2015

Thanks Ashley!

Although it's not perfect, it is a big improvement.

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.