Discussions

 View Only
  • 1.  ListUser field not working via Connected Table

    Posted 07-08-2019 13:07
    Anyone ever run into an issue where you have a ListUser field from a Connected table somehow converts to a data type of Text on the 'other side'?

    I've tried to also change the data type of the field on the destination side as well, but it's not an option.   Strange!


  • 2.  RE: ListUser field not working via Connected Table

    Posted 07-08-2019 13:33
    Right, so certain fields types do not natively Sync across in their original field types and default back to a "text" equivalent.

    For example a User field and a List User fields definitely come across as text.  

    For a User fields it's easy to create a new field  of type Formula user with a formula of

    ToUser ([user Sync field])


    But for the list user, the formula is more complicated.

    Here is a tested example of a formula that works and can be  extended to up to as many as you will likely have or else right up to the maximum which I think is 20 userids.


    var text StripOutSquareBrackets = NotRight(NotLeft([userlist],1),1);

    var user UserOne= ToUser(Trim(Part($StripOutSquareBrackets,1,",")));

    var user UserTwo = ToUser(Trim(Part($StripOutSquareBrackets,2,",")));
    etc...

    var user UserTwenty =
    ToUser(Trim(Part($StripOutSquareBrackets,20,",")));


    ToUserList($UserOne, $UserTwo, etc, $UserTwenty )