Re: Compare 2 fields

mklauss — Fri, 14 Aug 2020 17:35:47 GMT

Thanks so much Hilary, that is a great solution.

Re: Compare 2 fields

Hilary Stoupa — Thu, 30 Jul 2020 21:13:56 GMT

See if the attached sample is helpful. Right click the linked file, and save it locally. Right click the saved file and select design to open in design mode - then you can preview.

Compare 2 fields

mklauss — Thu, 30 Jul 2020 20:59:20 GMT

Hi all,

I've been trying to research a solution for this but either I am not entering the correct verbiage or it hasn't come up so far.

What I'm trying to do is to basically compare 2 fields and if the primary field is blank to then fill in a 3rd field with the data from the second field. More specifically I have a form that shows the Requested by field automatically and then I have a Requested for field which is to be filled in when the Requested for is different from the Requested by. I want the 3rd field to be populated with the Requested for if it is filled in or if it is blank to use the Requested by field. I've tried to concatenate and substring something but it only works when there is a Requested for filled in. Has anyone run across this before or maybe have a solution?

Thanks,

Mike

General

Re: Compare 2 fields

Re: Compare 2 fields

Compare 2 fields