Simply Checkbox that add data from entity1 to entity2

[tofsweden]

Is there any simple code that when I check on any box then ML101-1 is automatically added to the editform cardvalue?

Thanks in advance!

[tofsweden]

Anyone? It's amazing that there's no support for this from what I've seen. There is a complex blog about this however it is supported only by sharepoint as database behaviour are different from each other.

[Ancherl]

Hi,@tofsweden

According to your statement, I guess that if you check on ML101-1 box then ML101-1 is automatically added to the editform cardvalue and if you check on ML101-2 box then ML101-2 is automatically added to the editform cardvalue, and so on. Is that true?

Regards,

Ancherl

[tofsweden]

Hi @Ancherl

That is true!

Regards

[Ancherl]

Hi,@tofsweden

I am very sorry for late answer, but I want to ask a question for solving this problem better. The part as follows is a gallery and it is connected to a data source. 

Is that true?

Regards,

Ancherl

[Ancherl]

Hi,@tofsweden

If you check on ML101-1 box and ML101-2 box at the same time, ML101-1 and ML101-2 are both added to the editform cardvalue. Is that true? 

[tofsweden]

@Ancherl

ML101 belongs to a different entity (table) and is not connected to same datasource as the field where I want ML101 to be added.

In this screen, I have one detailform with datasource1 and one gallery (ML101) with datasource2.

So, to your answer it is true.

[tofsweden]

@Ancherl

Yes it is true, made possible by having the field datatype as multi-text!

Regards

[v-micsh-msft]

Hi @tofsweden,

Please check to see if the following would meet your requirements:

1. Configure the CheckBox OnCheck Property with the code below:

Collect(DataUse,Table({Value:Checkbox.Text&Char(13) & Char(10)}))

2. Configure the CheckBox OnUnCheck Property with the code below:

Remove(DataUse,{Value:Checkbox.Text&Char(13) & Char(10)})

3. Configure the Default property of the MultLine TextInput with the code below:

Concat(DataUse,Value)

Step 1 configure the CheckBox OnCheck property to collect checkbox.text into a single column table with the column named Value, Char(13) and Char(10) is used to CRLF.

Step 2 configure the checkBox OnUnCheck property to remove the item added,

Step 3 is used to combine the selected data into one string, which then could be shown under the Multline InputBox.

If you have any further questions, please post back.

Regards,

Michael

[tofsweden]

hi @v-micsh-msft

Could you use entity1 and entity2 to differ, so I could understand where to put code and also how does it direct the text frfrom entity2 (with ML101) to be put into the targeted DataCardValue that belongs to entity1?

What is CRLF?

Thanks

Example:

Do you mean: 

Collect(Entity1,Table({Value:Checkbox.Text&Char(13) & Char(10)}))

What is Char(13) and Char(10)? Should I replace them with ML101 fieldname?

edit;

If you mean datacard, then it says that Collect(DataCard18 is not valid, it have to be a datasource