The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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 ...
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:------------------------------------------...
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 ...
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:
...
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...
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...
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...
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.