ContributionsMost RecentMost LikesSolutionsNew App that vendors can log in and see there metricsI want to build a new app that our vendors can view their metrics with out having to use paid seats for them to log into. We need to basically compile data into tables and they can see the compiled data when they log in. So I guess I would need some sort of guest role? ------------------------------ Johnny DeVilla ------------------------------ New App that vendors can log in and see there metricsI want to build a new app that our vendors can view their metrics with out having to use paid seats for them to log into. We need to basically compile data into tables and they can see the compiled data when they log in. So I guess I would need some sort of guest role? ------------------------------ Johnny DeVilla ------------------------------ Re: Formula adding fields, but leaving one out if a certain wordThanks that works well!! ------------------------------ Johnny DeVilla ------------------------------ Re: Formula adding fields, but leaving one out if a certain wordmy solution was to pull from another field that has this formula and works well List(", ", IF(Contains(ToText([Field2]), "Hedge Hogs"), "Hedge Hogs"), IF(Contains(ToText([Field2]), "Pink Ribbons"), "Pink Ribbons"), IF(Contains(ToText([Field2]), "None"), "")) ------------------------------ Johnny DeVilla ------------------------------ Formula adding fields, but leaving one out if a certain wordI have a formula to name records in one of my tables that is something like: List(" - ",[Field1],[Field2],[Field3],[Field4],[Field5]) This works quite well for us, but when Field2 is selected as None I don't want None in the output. How would I write this so that when None it reads it as blank? ------------------------------ Johnny DeVilla ------------------------------ Upload field to appear on child tableI have several upload fields that I want to display on a related table. I believe I need a formula to do it, but I don't think I understand the syntax correctly. Re: I want to make my user-list field a dynamic filterReopening this thread in case a solution has been reached in the last year. I need a formula to change a / to \I have urls for various file paths for our assets that I would like to have an automatic way to feed another file path for pc users. Our Mac file paths look like this smb://WLVISILONCIFS/XXXXXXXXX/_XXXXXXXXX/2018/_XXXXXXXXX/08-Aug/XXXXXXXXX/Promo/XXXXXXXXX Can someone help with a formula that would change the above to WLVISILONCIFS\XXXXXXXXX\_XXXXXXXXX\2018\_XXXXXXXXX\08-Aug\XXXXXXXXX\Promo\XXXXXXXXX Re: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000Would this Right(Left([File Path],"/")&"\" change my slashes in a file path to the opposite? Re: Need help with a formula changing phone format from (000) 000-0000 to 000-000-0000That did it, thank you for the help!!