Adding links to link field from a calculation

Follow

Pete Steege

• November 17, 2022 16:42
• Edited

Hi,

I'm trying to create a calculation field that extracts urls from a 'text' field adds them to a 'link' field.

Currently i have this which adds the links to a comma separated string, and / or to an array, but neither the string nor the array  add the links. 

i.e 

link_field = array

link_field = comma_string

 

This is the code i have so far

var message = @Text_Field;
var link_str;
var link_array = [];
var temp_str;
var i;
var set_stop = false;


var urlRegex = /(((https:?\/\/)|(http:?\/\/)|(www\.))[^\s]+)/g;

link_str = message.match(urlRegex);


i = 0;

      do {

             temp_str = String(String(link_str).split(",")[(i)]);

             link_array[i] = temp_str;

             i++;

            }

while (i < 10);


@Link_Field = link_array;

 

I've also tried 'encodeURI, and also the Links field as a array  - 

i.e.

.. loop 

   @Links_Field[i] = link_array[i]

   i++

... 

 

Im pretty stuck on this so any help would be greatly appreciated.

 

Thanks,

Pete.

 

1

• 

  Rainer Grabowski

  • November 16, 2022 18:13

  You can't update other fields with a calculation in a Podio calculation field. Calculation fields are "only" for creating/calculating something that can be displayed in that same calculation field. For updating fields you need a flow (Podio Workflow Automation in your case).

  0

  Comment actions Permalink
• 

  Pete Steege

  • November 26, 2022 21:36

  Hi Rainer,

  Thanks for the response. I din't even think to check that first!

  Similar to displaying Images in calculation fields, i.e.  "", is there a similar way to embed videos / YouTube videos like how they appear in 'Link' fields? At the moment I can only display the clickable link.

  Thanks

  0

  Comment actions Permalink

Please sign in to leave a comment.