unable to concatenate the first 3 characters of one list field with another list field in shareoint infopath form
I am trying to concatenate a designator field that combines my autonumbered index field with the first 3 characters of my group field
Index field automatically incremented current Highest index +1
I have another field that needs to Join the first 3 characters of my group field with the index field
example
Index: 1008
Group: ABM Support
Designator: (Desired result) 1008ABM
I get an error in the InfoPath form when I try to use:
concat((LEFT(Group,3), Index)
Expected value type: )
Actual value: ,
concat((LEFT(../my:Group,3)-->,<-- ../my:Index)
I have two Items I need to combine as a Designator for a SharePoint list. I have been able to auto increment the Index number, and I need to combine the index and first 3 characters of the group field to create the designator. I realize now I cannot use a concatenate string i.e. concatenate(LEFT(Group,3), Index). The problem lies that there are no common consistent characters to set a substring statement up. I was thinking to Add a default space at the beginning of the input and use that but not really sure how to go about that. Please advise if that would work and how to go about it.
function sharepoint concat infopath
asked Nov 14 '18 at 16:27
Deezone13Deezone13
11
add a comment |
I am trying to concatenate a designator field that combines my autonumbered index field with the first 3 characters of my group field
Index field automatically incremented current Highest index +1
I have another field that needs to Join the first 3 characters of my group field with the index field
example
Index: 1008
Group: ABM Support
Designator: (Desired result) 1008ABM
I get an error in the InfoPath form when I try to use:
concat((LEFT(Group,3), Index)
Expected value type: )
Actual value: ,
concat((LEFT(../my:Group,3)-->,<-- ../my:Index)
I have two Items I need to combine as a Designator for a SharePoint list. I have been able to auto increment the Index number, and I need to combine the index and first 3 characters of the group field to create the designator. I realize now I cannot use a concatenate string i.e. concatenate(LEFT(Group,3), Index). The problem lies that there are no common consistent characters to set a substring statement up. I was thinking to Add a default space at the beginning of the input and use that but not really sure how to go about that. Please advise if that would work and how to go about it.
function sharepoint concat infopath
asked Nov 14 '18 at 16:27
Deezone13Deezone13
11
ok solved: final formula was easy enough Concat(Substring(1,3),Index). Kept trying (0,3) and getting out of range error. then finally figured placeholder was incorrect
– Deezone13
Nov 15 '18 at 19:24
add a comment |
I am trying to concatenate a designator field that combines my autonumbered index field with the first 3 characters of my group field
Index field automatically incremented current Highest index +1
I have another field that needs to Join the first 3 characters of my group field with the index field
example
Index: 1008
Group: ABM Support
Designator: (Desired result) 1008ABM
I get an error in the InfoPath form when I try to use:
concat((LEFT(Group,3), Index)
Expected value type: )
Actual value: ,
concat((LEFT(../my:Group,3)-->,<-- ../my:Index)
I have two Items I need to combine as a Designator for a SharePoint list. I have been able to auto increment the Index number, and I need to combine the index and first 3 characters of the group field to create the designator. I realize now I cannot use a concatenate string i.e. concatenate(LEFT(Group,3), Index). The problem lies that there are no common consistent characters to set a substring statement up. I was thinking to Add a default space at the beginning of the input and use that but not really sure how to go about that. Please advise if that would work and how to go about it.
function sharepoint concat infopath
asked Nov 14 '18 at 16:27
Deezone13Deezone13
11
I am trying to concatenate a designator field that combines my autonumbered index field with the first 3 characters of my group field
Index field automatically incremented current Highest index +1
I have another field that needs to Join the first 3 characters of my group field with the index field
example
Index: 1008
Group: ABM Support
Designator: (Desired result) 1008ABM
I get an error in the InfoPath form when I try to use:
concat((LEFT(Group,3), Index)
Expected value type: )
Actual value: ,
concat((LEFT(../my:Group,3)-->,<-- ../my:Index)
I have two Items I need to combine as a Designator for a SharePoint list. I have been able to auto increment the Index number, and I need to combine the index and first 3 characters of the group field to create the designator. I realize now I cannot use a concatenate string i.e. concatenate(LEFT(Group,3), Index). The problem lies that there are no common consistent characters to set a substring statement up. I was thinking to Add a default space at the beginning of the input and use that but not really sure how to go about that. Please advise if that would work and how to go about it.
function sharepoint concat infopath
function sharepoint concat infopath
asked Nov 14 '18 at 16:27
Deezone13Deezone13
11
asked Nov 14 '18 at 16:27
Deezone13Deezone13
11
edited Nov 15 '18 at 15:24
Deezone13
asked Nov 14 '18 at 16:27
Deezone13Deezone13
11
asked Nov 14 '18 at 16:27
Deezone13Deezone13
11
asked Nov 14 '18 at 16:27
Deezone13Deezone13
11
11
ok solved: final formula was easy enough Concat(Substring(1,3),Index). Kept trying (0,3) and getting out of range error. then finally figured placeholder was incorrect
– Deezone13
Nov 15 '18 at 19:24
add a comment |
ok solved: final formula was easy enough Concat(Substring(1,3),Index). Kept trying (0,3) and getting out of range error. then finally figured placeholder was incorrect
– Deezone13
Nov 15 '18 at 19:24
ok solved: final formula was easy enough Concat(Substring(1,3),Index). Kept trying (0,3) and getting out of range error. then finally figured placeholder was incorrect
– Deezone13
Nov 15 '18 at 19:24
ok solved: final formula was easy enough Concat(Substring(1,3),Index). Kept trying (0,3) and getting out of range error. then finally figured placeholder was incorrect
– Deezone13
Nov 15 '18 at 19:24
add a comment |
1 Answer
1
active
oldest
votes
Solution:
Concat(Substring(1,3),Index)
answered Nov 15 '18 at 19:27
Deezone13Deezone13
11
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53304706%2funable-to-concatenate-the-first-3-characters-of-one-list-field-with-another-list%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Solution:
Concat(Substring(1,3),Index)
answered Nov 15 '18 at 19:27
Deezone13Deezone13
11
add a comment |
Solution:
Concat(Substring(1,3),Index)
answered Nov 15 '18 at 19:27
Deezone13Deezone13
11
add a comment |
Solution:
Concat(Substring(1,3),Index)
answered Nov 15 '18 at 19:27
Deezone13Deezone13
11
Solution:
Concat(Substring(1,3),Index)
answered Nov 15 '18 at 19:27
Deezone13Deezone13
11
answered Nov 15 '18 at 19:27
Deezone13Deezone13
11
answered Nov 15 '18 at 19:27
Deezone13Deezone13
11
answered Nov 15 '18 at 19:27
Deezone13Deezone13
11
11
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53304706%2funable-to-concatenate-the-first-3-characters-of-one-list-field-with-another-list%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
ok solved: final formula was easy enough Concat(Substring(1,3),Index). Kept trying (0,3) and getting out of range error. then finally figured placeholder was incorrect
– Deezone13
Nov 15 '18 at 19:24