ContributionsMost RecentMost LikesSolutionsRe: API_GetUserRole | Multiple Roles Awesome, that worked. It's so weird, I must have been at it too long because prior to trying to loop everything I had both the access id and access name fields populating. Then for the life of me I couldn't get it to work pre-looping. Probably a silly syntax error... 'name' instead of '#text'. Either way, thank you! It's all working as expected now ------------------------------ Shane Miller ------------------------------ Re: API_GetUserRole | Multiple Roles Hey Chayce, Good to talk to you again. So I was able to find a work-around for this, but I'm down another rabbit hole with a similar issue that may be easier since you use and are familiar with this API. Firstly, so that I can help anyone down the road, here is the code to loop through the role id in the case there are multiple: {% set roles = b.json.qdbapi.user.roles.role %} {% set separator = "; " %} {% for role in roles %} {{ role['@id'] }} {% if not loop.last %}{{ separator }}{% endif %} {% endfor %} This creates a wonky output, but I fixed that by adding a formula - multi-select text field with a formula of: Split([Role ID (Generated by Pipelines)], ";") Now I can easily see both Role ID's. This works for the role names as well, and keeps them in the same order as the ID's as long as you don't have a ';' within the role name of course. Now for my hopefully easier issue. Are you familiar with how to pull the access name and access id from the api response? ------------------------------ Shane Miller ------------------------------ Re: Auto Deselect to show in User Pickers when user has no access or is on the Deny List. Just read that doc, really cool! I'll be playing with this. Thank you ------------------------------ Shane Miller ------------------------------ Re: Scheduled Pipelines url Hey Chayce, So the app I am working in is from the exchange called " Virtual Empower: App Library" by Ryan Pflederer. It's an incredible app that helps you manage your realm. One of the features allows you to "Refresh app schema". This takes you to a webpage where you add your user token and click submit to fire the script. I have altered the code page so that after clicking "refresh app schema", it does everything automatically. This is one step closer, but I would prefer if this happened every night at a specific time without me having to click the button. As for your question of what does the code page do, the code that Ryan wrote far excels my javascript and html knowledge, so I can't fully answer that, however, it is available for everyone to use. This isn't at all urgent, so please don't feel rushed to reply, though I am looking forward to continuing this conversation. Hope you enjoy your weekend! ------------------------------ Shane Miller ------------------------------ Re: Exact Forms Plus | error Wow, definitely a needle in the haystack. Thank you, that did the trick! ------------------------------ Shane Miller ------------------------------ Re: Exact Forms Plus | error Hey Keith, Thank you for getting back to me. Not sure if we are talking on the juiced cloud support as well, but I checked the clist and the applicable fields and there are not any rich text fields that exist in this use-case. To my knowledge, this was working just fine until I updated the document_templates table with a new document. We got a new logo, so that was what was updated. ------------------------------ Shane Miller ------------------------------ Re: Exact Forms Plus | error I don't have Keith's contact information. I did however create a juiced cloud support ticket. Hoping either there or here I will have an answer soon. Thanks Don ------------------------------ Shane Miller ------------------------------ Exact Forms Plus | error Hello, Has anyone ever seen this error? " Exact Forms Plus Encountered an ERROR! NO Document(s) were generated! We're sorry but something went wrong! The following error occurred: Name of style already exists Exact Forms Plus v11.5.10 " Any ideas on how to resolve it? Thank you ------------------------------ Shane Miller ------------------------------ Re: Exact Forms Plus | water mark I'll do that, thank you ------------------------------ Shane Miller ------------------------------ Exact Forms Plus | water mark Hello, I just discovered that there is a watermark feature for Exact Forms Plus! Sadly, I keep getting an error, and am hoping it's an easy fix. Here is the JuicedTech documentation. Watermark. This allows you to include a watermark in your output document. format is Text|Color|Font-Size (v9.4 and above) Here is my error message: ERROR CREATING WATERMARK IN DOCUMENT Object reference not set to an instance of an object.Make sure the wm url parameter is in the format wm=TEXT|COLOR|SIZE Exact Forms Plus v11.5.10 You'll notice I am on a higher version than the minimum v9.4 required. here is a portion of the code inside my formula url button: & "&efpdte=854" & "&wm=DRAFT|RED|65" & "&uid=855:" & UserToEmail(User()) & "&docfmt=docx&stream=y" If I comment out the watermark line, everything works perfectly. Any ideas? ------------------------------ Shane Miller ------------------------------