So, first question, Iโve created a column order but, I have two columns, one Phone (H) and other Phone (M), some people would have only Mobile number, so it would not show the phone icon in the view. But when Iโve set Phone (H) to show after Phone (M) in the column order under Views, there is a blank space where there would be Phone (M) phone icons. I was wondering if it were possible to make the column disappear from view if Phone (M) is blank.
Question 2, another related to Phone (H) and Phone (M), if a client has two phone numbers, as in Phone (M) and Phone (H), it duplicates the Phone icon and the Message icon twice, can I set it to automatically choose Phone (M) as those icons and not show another phone and message icons? You could say, these two questions would be related to one formula I suppose.
Question 3, I donโt know if I can add multiple questions hereโฆ if I get told otherwise, Iโll do it for future, making different question forums. When I click on a row in the view tab, for example, my client database, I click on a persons name, but I never found out how to change the heading of the selected person. It comes up with โDetailsโ only, where I would like to have it " Info." as an example. How would I do that?
Solved! Go to Solution.
Unfortunately, thereโs no (easy) way to do that: the expression that produces the view title is not aware which row is being displayed. My recommendation is to add a (possibly virtual) column of type Show at the top of the form that displays the desired text.
Q1 - What view are you using?
Q2 - Crate additional column likeโฆ if mobile column is blank, use phone, else use mobile
Q3 - You can change the columnโs header name with the option โDisplay nameโ. You can find it under columnโs definition.
Q2 answered both Q1 and Q2 ! Thank you! I just created a virtual column and made an IF statement to determine the priority, it has worked!
Q3 - I may not be asking it correctly, but here is a photo of what I mean,
I want to change the heading of when clicking on a client to make it their name then the word edit, for example, โJohn Smith editโ - something like that. I couldnโt figure out how the click commands would work, a client was selected in the table view, and then into the table details section of the row (client).
Unfortunately, thereโs no (easy) way to do that: the expression that produces the view title is not aware which row is being displayed. My recommendation is to add a (possibly virtual) column of type Show at the top of the form that displays the desired text.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |