DomainOf() Expression | not documented

[Koichi_Tsuji]

@Steve 

By chance or accident, we get to know this expression is available and working.

As far as I checked the official expression docs as well as announcement, this was never mentioned before (unless I overlooked the important announcement). 

If this is officially supported expression, @Steve  can you update the docs? Thank you!

@takuya_miyai 

[Steve]

Attn @lizlynch 

[Koichi_Tsuji]

 Currently no hit.

 

[Koichi_Tsuji]

@Steve 

On my own conclusion, the docs looks like this.

DOMAINOF()
TO EXTRACT THE DOMAIN TEXT OUT OF THE MAIL ADDRESS WHICH IS PASSED AS ARGUMENT TO THIS EXPRESSION.

Sample usage
DOMAINOF("abc@appsheet.com") returns appsheet.com

Syntax
DOMAINOF(email address)

email address - email address as textual value or column value whose data type is set to "email" type.

[Koichi_Tsuji]

By the way, we really wish to have XXXOF type of expression, such as INDEXOF() without twisting the expression heavily around...

I know DomainOf/IndexOF expression are bringing totally different result and there are different level of difficulties in terms of technical perspectives.

[Koichi_Tsuji]

With AppSheet, we are missing bunch of expressions to manipulate the arrays.

In appsheet terms, to manipulate the LIST.

This situation is not changing since I started AppSheet in 2017, hope the new solutions will be brought on to us .

[lizlynch]

Thank you @Koichi_Tsuji and @Steve . Bringing this to the attention of the AppSheet dev team to determine whether it should be officially documented. Stay tuned! Appreciate your raising this inquiry.
Liz

[Steve]

Curious why we have both DOMAINOF() and EXTRACTDOMAINS().

[Koichi_Tsuji]

DOMAINOF(USEREMAIL())=ANY(EXTRACTDOMAINS(USEREMAIL())) 

should return true?

Whatever the case, any addition to the expression list is always welcome.

@Steve 

[lizlynch]

@Koichi_Tsuji @Steve 
The following functions are now documented:

• DOMAINOF() - https://support.google.com/appsheet/answer/13127104
  (I used your suggested content -- thank you!)
• EXTRACTDOMAINS() - https://support.google.com/appsheet/answer/13124857

Thank you!
Liz