How to copy "lookup" column value to "single line of text" column in same list with Workflow? - InfoPath Dev
in

InfoPath Dev

How to copy "lookup" column value to "single line of text" column in same list with Workflow?

Last post 03-17-2011 07:59 AM by qwerty. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-17-2011 03:10 AM

    How to copy "lookup" column value to "single line of text" column in same list with Workflow?

    Hi Folks, I am having below list (list1) with 3 columns: Title | Project Name (look up) | Project Name2 (Single Line of Text) Is it feasible with Workflow to copy 'Project Name (look up)' columns data to 'Project Name2 (Single Line of Text)' ? Thx in advance. - Chintan
    Thanks,
    Chintan
  • 03-17-2011 07:59 AM In reply to

    Re: How to copy "lookup" column value to "single line of text" column in same list with Workflow?

    Hi Chintan. It's possible, but it is a little complicated (probably not if you have QRules! lol). Add an extra column to your list -- no need to display it in your form. Make it an Integer datatype with a default value of 0, and add a rule to this field to set Project Name2 to Project Name. This rule will go off in each line when the value of the field changes. Set the field's value to its value + 1 in another rule to start the copy. Make sure that you initiate this rule outside of the repeating table, or it will only work in one line. See the attached form template if you get stuck.

    Hope that this helps!

    Qwerty
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.