search

dcolley / integromat-facebook-support

0 stars 0 forks source link

I'm working on an integration between Gravity Forms, Integromat, and Airtab... #120

Open dcolley opened 3 years ago

dcolley commented 3 years ago

Source: copied from https://www.facebook.com/groups/integromat/permalink/3973116896132247/

I'm working on an integration between Gravity Forms, Integromat, and Airtable. I've linked two tables (say Estimate and Line Items) and there are two-four records attached The Estimate table.

When I do a search for a record in integromat, it returns 2 values my search looks like this: ({Calendar ID} = "{{6.Line ID)}}"

It returns the value: ({Lien ID} = "CB44de19d03, CB44de19d03, CB44de19d03, CB44de19d03"

How do I parse this down so that it looks like this? ({Line ID} = "CB44de19d03"

Even better, how do I concatenate this to be.... ({Line ID} = "CB44de19d03B"

dcolley commented 3 years ago

Comment ID: 3973160229461247 If possible then please share some images

dcolley commented 3 years ago

Comment ID: 3973240342786569 If it's an array as an output then you use an iterator and create a variable to concatenate

dcolley commented 3 years ago

Comment ID: 3973277329449537 use split: https://www.integromat.com/en/help/string-functions

split (text; separator)

and then you can run an iterator module

dcolley commented 3 years ago

Comment ID: 3973342439443026 If you can show the screenshot then it will be easier to suggest.

But from your details you can use iterator or split function. Both of either will work.