Automatically generate email based on QQ number
Entering a QQ number to automatically generate a mailbox involves handling null values.
We know that the QQ number is a string of numbers. As long as you connect @ qq.com to the QQ mailbox, you need to use the CONCATENATE string connection function. However, there is another situation to consider. If the QQ number is missing, directly use CONCATENATE, then the @ qq.com text will be directly output. Therefore, we must first judge whether a null value has been entered through ISEMPTY.
To sum up the function requirements: If the QQ number entered is not null, the returned result is "QQ + @ qq.com", otherwise (that is, if the QQ number is null) the returned result is "Please enter QQ number".
Formula settings
The following code can be directly copied to the formula editor,Replace QQ number field.
{"text":"IF(ISEMPTY(QQ号),\"请输入QQ号\",CONCATENATE(QQ号,\"@qq.com\"))","marks":[{"from":{"line":0,"ch":11,"sticky":null},"to":{"line":0,"ch":16,"sticky":null},"value":"textField_ksj5gm04","invalid":false},{"from":{"line":0,"ch":39,"sticky":null},"to":{"line":0,"ch":44,"sticky":null},"value":"textField_ksj5gm04","invalid":false}],"isCmData":true}
Take a look at the actual effect:
Splicing effect
Null effect
YIDA in order to better optimize the content and quality of YIDA user manual, it takes you 3-5 minutes to fill in the document feedback questionnaire. The document feedback questionnaire is submitted anonymously, and the questionnaire information is only used for YIDA document experience feedback collection. Thank you for your support for YIDA!
-------------------- Get the latest information YIDA, welcome to follow US--------------------
