Unanswered

Apps Edit Form Query

(1) Share

Report

Posted on by RLSid17

219

I have an Edit Form in my app and in this 1 field is a single line of text but inside that DataCard it has multiple checkboxes and depending on how many checkboxes were ticked it would concatenate those values, for example, I have these values in the checkboxes:

1- A

2- B

3- C

4- D

5- E

So I only select B and D so the result would be B D and that would save in that field. But there would be times that we need to edit that item again and we expected B and D to be still ticked but when we select E, that ticked B and D would disappear then we would need to tick those boxes again.

Ideally, we would change the field into checkboxes, but is there some way for this to work so the field would remain as a single line of text and would retain the last selected value of the checkboxes that is not connected to the form?

Categories:

General Questions

All responses (2)

Answers (0)

poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
Re: Apps Edit Form Query

@RLSid17

For the Default of each checkbox that you already have, try something like this

Self.Text in mySavedField.Text

Instead of mySavedField.Text above put whatever is appropriate for you for where the concatenated value is.
For Self.Text to work properly here, I presume that the Text property of each Checkbox control, has the correct matching value e.g. "A" for the A checkbox, "B" for the B checkbox, etc. - if that's not the case, it might be best to adjust each of your checkboxes so their Text property matches their actual value you intend them to have, to make this solution simple and avoid having to hard code "A","B", etc. in each checkbox, but instead to just use the same above simple formula for all the checkboxes. To me, it looks like your checkboxes might already be like that right now though, so this might work well for you.

See if it helps @RLSid17
Manan-Malhotra 621 Super User 2024 Season 1 on at

Like (0)

Report

Re: Apps Edit Form Query

I am hoping when you tick the old values you submit them through form and next time when you visit the same for you are unable to see those ticks
If this is the case, in the Default property of ticks please call the value for that particular record

However if if you reach this form by using a gallery, it should probably do that on its own

if this doesn't help, could you please share multiple screenshot for it