Discussions

 View Only
  • 1.  A number is pulling into a field I want text

    Posted 05-24-2022 18:45

    I am pulling the information via a relationship from one table to another.  However,

    This is the field I am having issues on

    the number is constantly showing up as a number.  It is the Proxy Reference too.

    What am I doing wrong?  I have encountered this before and have always been able to fix it.  Not today! 



    ------------------------------
    Jennifer Meyer
    ------------------------------


  • 2.  RE: A number is pulling into a field I want text

    Posted 05-24-2022 19:12
    Can you give us a screenshot of the relationship where that is being pulled in?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: A number is pulling into a field I want text

    Posted 05-24-2022 21:48


    ------------------------------
    Jennifer Meyer
    ------------------------------



  • 4.  RE: A number is pulling into a field I want text

    Posted 05-24-2022 22:03
    There is something messed up about that field. It is a numeric lookup field. I suggest you delete it and look it up again on the relationship.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: A number is pulling into a field I want text

    Posted 05-25-2022 10:26

    Mark,

    I have deleted it a few times.  It continues to show up as a numeric lookup.  Any thoughts?



    ------------------------------
    Jennifer Meyer
    ------------------------------



  • 6.  RE: A number is pulling into a field I want text

    Posted 05-25-2022 10:32

    The only explanation is that you must have a misnamed field on the Parent record. You must be pulling down the wrong field. 


    Check the field name that holds the Title. 



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: A number is pulling into a field I want text

    Posted 05-25-2022 10:35
    I did!  Once you helped me correct the numeric issue I traced it back to having the "company" field as the value field.  THANK YOU SO MUCH!

                






  • 8.  RE: A number is pulling into a field I want text

    Posted 05-25-2022 10:38
    Ok, you won the battle in the end!  Next time won't be so hard for you to fix.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 9.  RE: A number is pulling into a field I want text

    Posted 05-25-2022 10:45
    Yes! Thank you soooooo much!