jaybushman - profile

jaybushman · Mar 25, 2023

Hello. I'm struggling to find a way to combine the contents of several Multiple Select field into a new field, while retaining the value and color for each entry. Here's a stripped down version of what I'm trying to do: I've got 4 separate multiple s...

jaybushman · Mar 21, 2023

Hi. I'm trying to figure out how to use a Lookup Field to update another record in the same table. This is a simplified version of the workflow to illustrate what I'm trying to do:I've got a number of records, called "Sequences." I need to define the...

jaybushman · Mar 12, 2023

Hi all: I'm trying to simplify the process of converting a short ID code to a longer ID code inserting leading zeroes where needed. The ID codes are structured to track Week, Day, and Segment numbersFor example, if the input data is 1.2.3 (week 1, da...

jaybushman · Mar 29, 2023

Thanks a ton. I have been able to get this to work if I manually choose the records. But, as you originally pointed out, combining scripting with automation is only available for Pro accounts and we're only on Plus.

jaybushman · Mar 28, 2023

Thanks a lot! I used the Script Extension from this thread to create the formula:REGEX_REPLACE(SUBSTITUTE(SUBSTITUTE(IF({Type 1}, ARRAYJOIN({Type 1}) & ",") &IF({Type 2}, ARRAYJOIN({Type 2}) & ",") &IF({Type 3}, ARRAYJOIN({Type 3}) & ",") &IF({Type 4...

jaybushman · Mar 28, 2023

Using Scripting, I've been able to combine several multiple select fields into one as a string. But I can't figure out how to convert that string to another multiple select field

jaybushman · Mar 26, 2023

I'm on a Plus account, but I think that does give me access to the scripting extension. I will give that a try. Thanks!

jaybushman · Mar 25, 2023

Thanks. I updated it with the Find Record action, but it keeps failing at the final step:In that last step, I feel like the problem is with the field specified for "Record ID." In the screenshot, it's set for "Next | List of 'id'", and it doesn't wor...

User Statistics

User Activity

Combining several Multiple Select fields into a new field

Using a Lookup Field to update another record in the same table

simplifying conversion of Week/Day/Segment ID with leading zeroes

Re: Combining several Multiple Select fields into a new field

Re: Combining several Multiple Select fields into a new field

Re: Combining several Multiple Select fields into a new field

Re: Combining several Multiple Select fields into a new field

Re: Using a Lookup Field to update another record in the same table