Jessica_Shin - profile

Jessica_Shin · Aug 26, 2023

I have a column that has strings of option lists, and I would like to extract only one option "COLOR=" ,between the comma & " "(space), from them. These option lists sometimes include different language letter so It must extract english only.Here we ...

Jessica_Shin · Apr 03, 2023

I set up schedule automation to find records under certain condition and delete those records.however, using script to delete the found records doesn't seem to work.the script I'm using here is the following:------------------------------------------...

Jessica_Shin · Jul 11, 2022

Hi, here I have a column shows tracking number from multiple shipping carriers. some are something like ‘6495-4289-3463’(number+‘-’) or some are like ‘343918 ai19’ (text+number+space). I would like to turn these into only number and text without any ...

Jessica_Shin · Jun 22, 2022

Hi, Is there any formula that can be used to find the best matching block from the table? please help! for example, I have an input that’s collective of words as a product name: YELLOW PRETTY WOMEN’S BAG in a meanwhile, my inventory data would have: ...

Jessica_Shin · Feb 24, 2022

I’m having a trouble connecting rest API for one of the tables that collects sales data for my business. Since I cannot share streaming graphs of this data in airtable with my partners, I would like to bring in airtable data to power BI so that I and...

Jessica_Shin · Aug 26, 2023

this totally works! thank you so much!

Jessica_Shin · Apr 07, 2023

This worked!!! thank you sooooooo much!

Jessica_Shin · Apr 06, 2023

Hi Adam, thanks for your solution.adding 's' to the script seems to work but now I get different error sign :ERRORError: Request exceeds maximum batch size limit of 50 items at main on line 4 number of items to delete can be from 0 to 500 sometime...

Jessica_Shin · Jul 11, 2022

Thank you so much! Didn’t realized that I have to define the textInput on the leftside of the edit script window. It may help others who have trouble like me. Hope this helps: const textOutPut=input.config().textInput.split(’ ‘).join(’‘).split(’-‘).j...

Jessica_Shin · Jul 11, 2022

Thank you for the reply Alexey, Following your script, I should replace text as {tracking number} and ‘txt’ as ‘{tracking number}’? If so, it doesn’t seem to work. I don’t know about coding so much. thanks again in advanced.

User Statistics

User Activity

regex extract - string between the commas & english only

automation : deleting arrays

Trim& substitute using script

Find best matching item name

Import Airtable to Power BI -> not working

Re: regex extract - string between the commas & english only

Re: automation : deleting arrays

Re: automation : deleting arrays

Re: Trim& substitute using script

Re: Trim& substitute using script