I've got a simple form connected to a single SharePoint list. I want to make the Title field a comination of 2 fields in the form.
Colum names:
Title shoud be:
[client name]-[type of service]
I cannot seem to find the correct way to accomplish this. I'm assuming an update to the field must be done at the time of submitting the form with the button.
Solved! Go to Solution.
For anyone who finds this later. We figured out the answer in another thread that was happening at the same time. Thread with answer.
@sweetwaterbrew will you mark this post as the answer so people can find it later? And if I make it back to ATL you are on for a beer.
{Title: ClientName.Text & "-" & TypeService.Text}
That might not be perfect syntax but that is really close if it isn't. 🙂
Get you close enough?
You are right, that isn't going to work on FormSubmit. Let me try out an idea.... Okay. Got it. (Thankfully you didn't have to actually wait while I tried.)
So on my new form I set Title Default to be ClientName & "-" & TypeService
I also set Title to DisplayMode to DisplayMode.view that way the user cannot type in anything. You could also just set Visible to False if you don't want them to see it.
How about that for chaotic circle fun?
Unfortunately, I'm not having any luck with it. I've even tried just setting the Title field to be just the client name. Nothing seems to update the Title field with the other field's text while filling out a new form.
If I open an existing item, the Title field is changed to be the client name.
Is there some action that needs to happen to tell the Title field to populate while filling out the form for a new item?
For anyone who finds this later. We figured out the answer in another thread that was happening at the same time. Thread with answer.
@sweetwaterbrew will you mark this post as the answer so people can find it later? And if I make it back to ATL you are on for a beer.
User | Count |
---|---|
141 | |
137 | |
78 | |
77 | |
72 |
User | Count |
---|---|
228 | |
178 | |
68 | |
68 | |
58 |