Milos_Milosavlj - profile

Milos_Milosavlj · Apr 05, 2021

Hello, I am trying to substitute all the occurrences of ", " (comma, space) in a Lookup field with “%20” and place that into the formula field.

Milos_Milosavlj · Apr 04, 2021

Hi, is it possible to place an empty field on a page, in Page Designer App, that another user can then complete, like on a Form. If not, is there any other way to present a single record to another user, and have the fill in missing data.

Milos_Milosavlj · Apr 05, 2021

Hi Kuovonne, First of all, I have to give you a shout out for the Prefill Forms app. Brilliant and mega useful. Scott’s Array formula is good enough. I placed hyphens and the demarcation is fine now, since I don’t see a way for Prefill Forms to rende...

Milos_Milosavlj · Apr 05, 2021

Works. You’re a star!

Milos_Milosavlj · Apr 05, 2021

ScottWorld: SUBSTITUTE( {Inquiry: Skills List Internal} & “”, “,”, “%20”) The formula works when I apply it on a single line text field, but not a lookup field or formula field (I just copied the lookup string into a formula field by inserting...

Milos_Milosavlj · Apr 05, 2021

@ScottWorld , is the source field a Lookup field in your case as well?

Milos_Milosavlj · Apr 05, 2021

ScottWorld: SUBSTITUTE( {Inquiry: Skills List Internal} & “”, “,”, “%20”) Hm, @ScottWorld it removed the commas, but did not substitute with “%20”

User Statistics

User Activity

Substitute characters in a string with another set of characters

Input fields on Pages

Re: Substitute characters in a string with another set of characters

Re: Substitute characters in a string with another set of characters

Re: Substitute characters in a string with another set of characters

Re: Substitute characters in a string with another set of characters

Re: Substitute characters in a string with another set of characters