Jump to content
  • 0

Get Values From List - String Into Text Field


Question

Hello all,

Has anyone figured out a way to get List - String values into a single text field, for lookup table and trigger uses? I have an app that currently uses a List - Sting datatype for one of the fields, and I need to be able to use this field in another app. However, I can't select it due to List - String not having much compatibility. I am wondering if anyone has figured out how to use a formula or something to list all of the values separated by commas and spaces or something of the sort.

I am trying to either display the list string value or select it with something like a cascading element, on a submission form. On cascading, the list string field doesn't show up in the datasource list. 

Any help is appreciated.

Link to post
Share on other sites

8 answers to this question

Recommended Posts

  • 0
17 minutes ago, kpcollier said:

I appreciate the help, @TellMeWhy.

Sure!

Btw, I found a way

<script>

document.querySelector("input[id^='InsertRecordList']").addEventListener('change', function() {
  
document.getElementById('cbParamVirtual1').value = document.querySelector("input[id^='ComboBoxInsertRecordList']").value;
  
});

</script>

The input with id starting with InsertRecord**FieldName** stores the checked values, so you can just use that as a reference to listen for a change
image.thumb.png.015cc128125e95ad43fed99abc814545.png
 

You can try it out again https://c2aby549.caspio.com/dp/83ff8000344c2f4c1794467fb6e2 

Cheers!

 

Link to post
Share on other sites
  • 0
Posted (edited)

Still having trouble with this. When options are selected in a List String box, the values are shown comma delimited on the value box. I feel like I should be able to copy the contents of that to another text field on change.

I believe the List Box actually is basically two elements - a select element with the options to choose from, and then an input element to store the values. The input element seems to be the one I need to target. The problem I am having is it is sending an integer value instead of the text value, which I am guessing is which index position each value is? Not sure. Any help would be appreciated. 

* Looks like there is a <label> element for each option. That is where the text is coming from. I believe this is what I need to target, but I am not sure how to get it done. This post shows to select the nearest element to the label with .next, but I couldn't get it to work. 

document.addEventListener('DataPageReady', function() {

  var n1 = document.querySelector('[id^="InsertRecordJob_Type"]');
  var n2 = document.getElementById('InsertRecordJobTypeString');

 n1.addEventListener('change', function() {
    alert("There was a change! Javascript is working!");
    n2.value = n1.value;
    

});
});

 

Edited by kpcollier
Link to post
Share on other sites
  • 0
Posted (edited)
$('[id^="InsertRecordJob_Type"]').change(function() {
  alert("hi");
  $("#InsertRecordJobTypeString").val($(this).closest('div').find('label').text());

});

This one is successfully copying the labels into the text field. However, it is copying all of the labels from the list string box. Not sure how I can limit this to only options that are checked, but it seems I am getting closer.

I am novice with jQuery and JS and learning about .closest() and .next(). The label elements are directly beneath the input elements. I believe I need to use .next(), but can't quite seem to get the values to show at all with it.

Edited by kpcollier
Link to post
Share on other sites
  • 0
41 minutes ago, kpcollier said:

$('[id^="InsertRecordJob_Type"]').change(function() {
  alert("hi");
  $("#InsertRecordJobTypeString").val($(this).closest('div').find('label').text());

});

This one is successfully copying the labels into the text field. However, it is copying all of the labels from the list string box. Not sure how I can limit this to only options that are checked, but it seems I am getting closer.

I am novice with jQuery and JS and learning about .closest() and .next(). The label elements are directly beneath the input elements. I believe I need to use .next(), but can't quite seem to get the values to show at all with it.

I'm confused what are you using? MultiSelect Dropdown or Listbox, afaik, Listbox doesn't display the concatenation of choices, right?

Is this what you're trying to do?

https://c2aby549.caspio.com/dp/83ff8000344c2f4c1794467fb6e2

Link to post
Share on other sites
  • 0
1 hour ago, TellMeWhy said:

I'm confused what are you using? MultiSelect Dropdown or Listbox, afaik, Listbox doesn't display the concatenation of choices, right?

Correct! I was trying with either way. Every post on this forum I have been able to find about List Sting fields have said this is impossible, so I was trying with both ways. First I was trying with dropdown and couldn't get only one value to show up. Then when I tried the listbox I saw the label elements. I guess devtools was making it more confusing for me than it was. 

Your workflow is what I am trying to do - get the selected values of a list string into a text field so that they can be used in triggers/lookups and such. I am guessing the 'Type on this after making selections' field is needed to make this work? Is it possible to have the event fire when an option is selected?

Link to post
Share on other sites
  • 0
50 minutes ago, kpcollier said:

Correct! I was trying with either way. Every post on this forum I have been able to find about List Sting fields have said this is impossible, so I was trying with both ways. First I was trying with dropdown and couldn't get only one value to show up. Then when I tried the listbox I saw the label elements. I guess devtools was making it more confusing for me than it was. 

Your workflow is what I am trying to do - get the selected values of a list string into a text field so that they can be used in triggers/lookups and such. I am guessing the 'Type on this after making selections' field is needed to make this work? Is it possible to have the event fire when an option is selected?

I can't seem to make it work on click, even using the whole document to check/listen for any change, it does not work for it, I don't know what's going on. Additionally, for some reason, if you checked it, it's not 'saved' you can check the 'for' of those labels and it still says 'unchecked' however when you click outside the options and close the dropdown, it will now include 'checked' so, that's when it's probably saved.

 

<script>
document.addEventListener('change', function() {

document.getElementById('cbParamVirtual1').value = document.querySelector("input[id^='ComboBoxInsertRecordList']").value;

});
</script>

Here's my script, there's an input element that has an ID which starts with "ComboBoxInsertRecord**ListFieldName**" . It does not show any values though even when options are checked, but, that's what's keeping those displayed on the field.

It will probably be better to do BeforeFormSubmit than 'change' in this instance.
https://howto.caspio.com/datapages/ajax-loading/ 

 

 

Link to post
Share on other sites
  • 0
22 minutes ago, TellMeWhy said:

Here's my script, there's an input element that has an ID which starts with "ComboBoxInsertRecord**ListFieldName**" . It does not show any values though even when options are checked, but, that's what's keeping those displayed on the field.

I appreciate the help, @TellMeWhy.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...