Record Collection Field Values on a Single Field on LF Form

asked on August 25, 2022

Hi there,

This issue of mine probably have a very simple solution. I’m trying to record the values of a collection field on a single field. I searched the answer in the forum and there are some but when I tried it on my form it didn’t fix my issue. Basically, I have a collection field that captures contact names. Then I’ll ask a question to the user as if they mentioned a specific contact above on those fields. If so, I’d like to get them to choose the name from a single/drop-down field. So, even if the user enters 10 contacts, the field should record all of them and show it to the user to choose and if the user deletes a row from collection field, the single field should update the values. I’m trying to do this to avoid unnecessary double data entry and if there is a better solution, please let me know. Here is a screenshot of what I would like to do. We are using 10.2 version

How can I achieve this? Calculation, javascript? Let me know. Thank you very much!

LF question.png (27.98 KB)

| Download

0 0

SELECTED ANSWER

replied on August 26, 2022

There are three ways I would handle this instead.

1) Add a checkbox to the collection that when checked copies that one contact into the Accounting Contact Name field. For this you would most likely then need to disable the other checkboxes in the rest of the collection when one is checked.

2) Add a checkbox as done above but turn it into a button. The following link is where I got the idea, they use it in a table to sort the rows but can be modified to show just one 'button' and copy data instead: https://answers.laserfiche.com/questions/113991/Table-Rows-Position

3) Add a custom button to the collection with custom HTML that when clicked copies that one contact into the Accounting Contact Name field overwriting any value currently there.

This is code I used in a collection of parents/guardians that then copied the data into an emergency contact table. Yours would be a bit simpler because you don't have a table to copy into. The function addNewEmergencyContact() is where I add the values into the table so would not be needed for you, instead just copy the data into the field at that point.

The JavaScript

function addEmergencyContactFromParent(theButton) /* called by button click in collection */
{

  var currFirstName = $(theButton).parents('ul.rpx').find('.nameFirst input').val();
  var currLastName = $(theButton).parents('ul.rpx').find('.nameLast input').val();
  var currPhone = $(theButton).parents('ul.rpx').find('.phone input').val();
  var currRelationship = $(theButton).parents('ul.rpx').find('.relationshipToStudent input').val();
  var currPronouns = $(theButton).parents('ul.rpx').find('.pronouns input').val();

  addNewEmergencyContact(currFirstName, currLastName, currPhone, currRelationship, currPronouns); 

  $(theButton).parents('ul.rpx').find('.parentAddedToEC input').val("true").change();
  
};

The custom HTML

<button type="button" class="emergencyContactButton" onclick="addEmergencyContactFromParent(this)">Add to Emergency Contact List</button>

2 0

Question

Question

Record Collection Field Values on a Single Field on LF Form

Answer

Replies

Sign in to reply to this post.