mrackley / StratusForms

Lightweight InfoPath alternative for SharePoint 2007,2010,2013,2016,2019 and Office 365
82 stars 36 forks source link

Force feed StratusFormsData field #21

Closed btroop202 closed 6 years ago

btroop202 commented 6 years ago

Good day, I am trying to use a work flow to create a new item in a different list (list B) when a item is created in list A.

But I am having issues with the % / characters

so I am trying to set a local workflow variable to: {"StratusFormsRepeatable":[],"ROSTER_x003a_Rank_x0020_Last_x00":[%Current Item:Rank Last, First%],"ROSTER_x003a_DoD_x0020_ID":[%Current Item:DoD ID%]}

Any suggestions?????

Thanks, Darrin

btroop202 commented 6 years ago

OK I figured it out, instead of one big statement I had to break it down to parts

So I create 3 new local workflow variables: SFpart1 = {"StratusFormsRepeatable":[],"ROSTER_x003a_Rank_x0020_Last_x00":'

SFpart2=" ,"ROSTER_x003a_DoD_x0020_ID":"

SFpart3= "}

The in the final variable I put it all togeter: [%Variable: SFpart1 %][%25Current Item:Rank Last, First%25] [%Variable: SFpart2 %][%Current Item:DoD ID%] [%Variable: SFpart3 %]

So now I can create a linklist through code

mrackley commented 6 years ago

Very cool... great job!