Newb needs help with formula. If field contains (text) then fill field with custom value

AppSheet AppSheet Q&A
1

Hi everyone.

I really like Appsheet, but am having trouble understanding the formulas.

I am getting data from a Googlesheet that updates regularily with data from an API

So in Appsheet, I have a field that gets a url, example http://www.google.com

I want to make this field change the url to http://www.google.com/example

So I was wondering if I can make a formula that states… whenever the field is populated with a url that contains “google” , change the field to my custom url ( http://www.google.com/example )

ie. IF url contains “google” then url = http://www.google.com/example

OK I hope that makes sense

Thanks

-Dave

2

Try below in a virtual column

IF(
 CONTAINS([column updated by API],"google"),
 [column updated by API] & "/example",
 [column updated by API]
)
3 Likes
3

Thanks TeeSee, you are the best!

1 Like