Is it possible to make app sheet keep spacing or forcing text to next line?
I am also interested if it is possible to create error if valid if is violated.
May I ask before where do you need that forcing? In a single valueโฆ workflow etcโฆ
You can create your own error message with the virtual column.
@Aleksi_Alkio ahhha the answer is away in a virtual column or concatenate something.
I am using it as part of a sign-up form, Iโm making my customers use a Google account because Iโm using their email address inside of numerous different primary keys that store info that I can use in other apps.
@Aleksi_Alkio thank you for your help, I canโt seem to get it to work, space here space there, nothing seems to work. I got it to work in text In a show column, just not in other column, I will try putting it in description field tonight.
Check if this would help to understand the formatโฆ
CONCATENATE(โEmail Addressโ,"space ",โspace โ,โ(must be @google.com)โ)
@Aleksi_Alkio I still couldnโt get it to work, but itโs ok I am not going to use app sheet for the sign up form for my app, I am most likely going to use a Wordpress plugin form that allows for me to set up reoccurring debits.
Do you think it matters that I am using the display name field?
Thank you for your help
May I ask what is the app name, your Appsheet account and from where I can find this expression. If thatโs okay for you.
SignUpForm-369532,
369532, Seller Email in row two in the display name field.
Okayโฆ the reason is the "Display name " option. Because you want to see the explanation on the form, you should add it into to โDescriptionโ field.
Thank you so much
Youโre welcome
It worked, but I have to say that is difficult to figure out, I canโt stand not understanding how things work, Cheers! Dan
@Aleksi_Alkio Thank you Translate
You can use โDisplay nameโ but because it will show the value in a table view as a header, you canโt have line breaks (we are showing only one row for the header). When you type that expression into the โDescriptionโ, it will show it only on the form view and thatโs why the line breaks are working.
If you use only โDisplay nameโ, it will show it on both (views and form). If you use both options, the โDescriptionโ will overwrite the โDisplay nameโ value.
That makes a lot of sense, I really appreciate the explanation. I donโt mean this to be critical, but how would someone like me(more will than skill) learn that, is it possible to have the system throw up a warning letting me know that app sheet is truncating or removing spaces, why and how to make it work.
If I missed this warning I am going to feel really silly.
Have a great day and thank you again.
You are not throwing criticismโฆ itโs from the real world
Which one? The line spacing or the error message?
It wonโt be a pop up like I would have liked, but a large text red virtual column should be enough to inform the customer that they need to change and read the instructions.
I still donโt understand spaces. I am looking for increased spacing to give the impression it is title then a description.
Example :Distributor ID/ Customer ID (this is established by the producer/manufacturer)" I would like a new line for the (โฆ) part.
CONCATENATE (โDistributor ID/ Customer IDโ,"
โ,โ(this is established by the producer/manufacturer)")
Is it possible to force a new line or multiple spaced because when I tried using concatenation it removed all but one space?
Try use Ideographic Space โ ', to me work in headers. I donโt now if in other behavior works.
http://emptycharacter.com/
CONCATENATE (โDistributor ID/ Customer IDโ,"
โ,โ
โ,โ(this is established by the producer/manufacturer)")
@Aleksi_Alkio I think I am missing something
CONCATENATE(โEmail Addressโ," โ,โ โ,โ(must be @google.com)
Gives the result I am looking for in the expression builder but in the form view in app sheet it end up being:
"Email Address (must be @google.com)
I think Iโve had problems like this and what I did was to put the following in a column in my spreadsheet so that I could then use that column (perhaps with a name like โ[Line change]โ in a concatenate expression:
"
"
Though you canโt see it, thereโs a space after the first quotation mark and that is followed by a return.
I didnโt something similar to get directional quotations marks into my app:
Hereโs a related trick I used to place an extra line before a โheaderโ that looks like this:
The โW to Dโ line is as follows:
Iโve turned off the little heading that normally would appear on top of this text as follows:
Try wit this one and please aware of the space like
Address","space
CONCATENATE(โEmail Addressโ,"
โ,โ
โ,โ(must be @google.com)")
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |