This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Scenario —
Tables are listed as such:
Address
Address 2 (for Suite number, Apartment, etc.)
City
ST
Zip
I’m making a formula in a table. If I make the formula
{Address} & “,” & {Address 2} & & " | {City} & “,” & {ST} & " "
Result:
123 Any St., Su...
I could not figure out why when doing an alphabetical sort, some records were coming in “at the bottom.” For example I’d have A to Z for records 1 to 100 followed by a second A to Z of records 101 to 200. I could see no extra spaces, or anything to i...
Another idea would be to make one base with lots of fields, and a table that’s a lookup for the types (books, articles, videos).
In the “All View” you can see everything from each of the three categories. In “Book View” you can filter it by the type ...
Jeremy_Oglesby:
{Address} & IF({Address 2}, “, “ & {Address 2} & “ “, “ “) & “| “ & {City}…
Sadly it’s still not working. I’m not sure what’s going on on my end. “Sorry, there was a problem saving this field. Invalid formula. Please check your...
