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,
I have a table that I put numbers to all the columns daily.
And I have a problem making a chart out of this.
This table represents the visitor numbers of my website daily and I want to visualize the ratio of the visitor’s age group in total.
colu...
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.