You are viewing limited content. For full access, please sign in.

Question

Question

Cloud Redtail Integration Dynamic Fields

asked on April 22, 2021

We are using Laserfiche Cloud and we want to use our list of Clients in Redtail as a dropdown. Does the current integration options with Laserfiche Cloud support this? How would we enable this?

 

My best guess at this is to use a workflow to iterate through all the clients and create a lookup table that stores everything and then use that for the dynamic lookups. I was hoping for a cleaner way to do it that would update as Clients update in Redtail. 

0 0

Replies

replied on April 22, 2021

Dynamic fields in the repository can only be tied to lookup tables. You will need to bring the Redtail data into a lookup table to achieve this. The most efficient way is probably to export an excel file of the Redtail data and use a workflow to Replace the entire lookup table regularly. 

Setting up Redtail as an application connection will help you push LF changes to that lookup table back to Redtail, but it wouldn't be as useful to track individual Redtail changes to update the lookup table. 

0 0
replied on April 26, 2021

Just thought of another way to do this. 

Instead of adding the Redtail list to your metadata field directly, you could instead build the entire metadata template out as a form. Create a process and build the starting form to have the same fields as your metadata template. You can set up an application connection lookup rule to fill the form field with your Redtail clients. This should give the form the exact experience you are looking for in the metadata pane. 

In the repository, you can use custom metadata panes to show the form in the web client right pane. Instead of users interacting with the metadata fields directly, they will interact with the starting form. 

Some notes about the business process behind the form:

  1. Instead of showing the thank you page after submission, redirect back to the starting form URL so the form just shows up again (like the metadata pane would)
  2. The form should have a hidden field that's filled via URL parameter with the selected entry ID. That way, each submission knows which document metadata needs to be modified. You can use the field picker in the custom tab configuration to insert the starting form URL and the entry ID as a parameter. 
  3. After submission, run a workflow service task with the entry ID to update that document's metadata. 

 

To recap:

  • Build a form with the application connection to Redtail
  • Embed the form next to the documents in the repository
  • Have the form submission update the actual document metadata

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.