Is it possible to make app sheet keep spacing...

(Daniel Armstrong) #1

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.

(Aleksi Alkio) #2

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.

(Daniel Armstrong) #3

@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.

(Daniel Armstrong) #4

@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.

(Aleksi Alkio) #5

Check if this would help to understand the format…

CONCATENATE(“Email Address”,"space ",“space “,”(must be @google.com)”)

(Daniel Armstrong) #6

@Aleksi_Alkio

I am 95% sure I tried that but I will

try It tonight thanks again for your help.

(Daniel Armstrong) #7

@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

(Aleksi Alkio) #8

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.

(Daniel Armstrong) #9

SignUpForm-369532,

369532, Seller Email in row two in the display name field.

(Aleksi Alkio) #10

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.

(Daniel Armstrong) #11

Thank you so much

(Aleksi Alkio) #12

You’re welcome

(Daniel Armstrong) #13

It worked, but I have to say that is difficult to figure out, I can’t stand not understanding how things work, Cheers! Dan

(Daniel Armstrong) #14

@Aleksi_Alkio Thank you Translate

(Aleksi Alkio) #15

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.

(Daniel Armstrong) #16

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.

(Aleksi Alkio) #17

You are not throwing criticism… it’s from the real world :slight_smile:

(Aleksi Alkio) #18

Which one? The line spacing or the error message?

(Daniel Armstrong) #19

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.

@Aleksi_Alkio

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.

(Aleksi Alkio) #20

CONCATENATE (“Distributor ID/ Customer ID”,"

“,”(this is established by the producer/manufacturer)")