Announcement

Collapse
No announcement yet.

SC6: ID showing with the descriptions {URGENT HELP}

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SC6: ID showing with the descriptions {URGENT HELP}

    Hi Guys;

    I've country table with id, country_name, using id in the form to display the country name, now its showing id as well with the country name, with SC5 was working fine.

    is there any solution to fix this issue...
    thanks in advanced
    ahmer

  • #2
    Re: SC6: ID showing with the descriptions {URGENT HELP}

    Hello,

    Could you provide a little more of information regarding this issue?

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Re: SC6: ID showing with the descriptions {URGENT HELP}

      its simple

      country table has 2 fields
      1. id
      2. country_name

      my other customer table, i'm using the country_id to display the country, in customer table im using lookup to display the country and that is read-only field no change on input/modify, now the problem is its showing the country id as well like example given below...

      Country: 1 Canada
      Technician Name: 3 John
      Appliance: 2 Dish Washer
      Building Manager: 94 John Doe

      I dont want to display the 1 for Canada id, and all the ID's are displaying
      same thing happening with my all the fields which is I gathering from the other tables, like technician, appliances,

      hope this will elaborate for your consideration...
      thanks
      ahmer

      Comment


      • #4
        Re: SC6: ID showing with the descriptions {URGENT HELP}

        Hello,

        Remove the ID from your select statement.

        E.j.

        Current Statement:

        Code:
        SELECT ID, Country 
        FROM Country 
        WHERE ID = {SomeField}
        New Statement:

        Code:
        SELECT Country 
        FROM Country 
        WHERE ID = {SomeField}
        Notice that the ID is not on the selected fields anymore.

        regards,
        Bernhard Bernsmann

        Comment


        • #5
          Re: SC6: ID showing with the descriptions {URGENT HELP}

          Thanks Bernhard;

          I double checked, its the same sql I'm using

          SELECT Country
          FROM Country
          WHERE ID = {SomeField}
          but still its showing the country_id in read-only display
          is any other solutions for this or this is the SC development bug.
          what do you think...

          Regards...
          Ahmer

          Comment


          • #6
            Re: SC6: ID showing with the descriptions {URGENT HELP}

            Hi,
            seems to be a bug. Well, one actually don't know, could be a feature as well. :-)

            Until it's fixed you can set the field type as SELECT and disable it. Doesn't look pretty but works.

            jsb

            Comment


            • #7
              Re: SC6: ID showing with the descriptions {URGENT HELP}

              Hello,

              Have you tried unmarking "Use lookup to display field description".

              regards,
              Bernhard Bernsmann

              Comment


              • #8
                Re: SC6: ID showing with the descriptions {URGENT HELP}

                Yes, I did un-checked "Use lookup to display field description" and now its showing only the country id

                any help...

                Comment


                • #9
                  Re: SC6: ID showing with the descriptions {URGENT HELP}

                  Can you set the id field disabled? Somewhere near the label radio button.
                  Albert Drent
                  aducom software netherlands
                  scriptcase partner, reseller, support and (turn-key) development
                  www.scriptcase.eu / www.scriptcase.nl

                  Comment


                  • #10
                    Re: SC6: ID showing with the descriptions {URGENT HELP}

                    Yes, it already disabled and label field I'm using, but the problem is its showing ID as well

                    any solution

                    Comment


                    • #11
                      Re: SC6: ID showing with the descriptions {URGENT HELP}

                      Try to setup a sample in a separate application. I too have similar problems. I set a field to read-only, labeltype, or label checkbox, but the field repeats to be editable. Somehow things gets mixed up and your problem looks like a similar one. If your test app appears to work then you might want to send screenshots to SC?
                      Albert Drent
                      aducom software netherlands
                      scriptcase partner, reseller, support and (turn-key) development
                      www.scriptcase.eu / www.scriptcase.nl

                      Comment


                      • #12
                        Re: SC6: ID showing with the descriptions {URGENT HELP}

                        Hello Ahmer,

                        I recommend you to contact our support regarding this issue. They will be able to guide you on how to setup your field without showing its id.

                        regards,
                        Bernhard Bernsmann

                        Comment


                        • #13
                          Hi All,
                          Sorry to bring this topic back to live.

                          I am facing exactly the same issue as described in this thread but unfortunately this thread ended up without a solution. Does anyone out there got any suggestions?

                          I am using sc 8.00.0022

                          My field (user_id) is in a 'Multiple Record Form'

                          When running the app I need to have this field disabled so user can not edit and it should display the the username instead of the id. At the moment it is displaying both id and the name when i use automatic grid lookup.

                          So far i have tried setting this field as 'Text, 'Select' and 'Label' but no luck.

                          Appreciate if anyone can give me a clue if knows the answer to this.

                          Aari

                          Comment


                          • #14
                            You can always add a custom field and fill this with the desired data to be retrieved in a onloadrecord event or similar. Hide the fields you don't want to display and you're done.
                            Albert Drent
                            aducom software netherlands
                            scriptcase partner, reseller, support and (turn-key) development
                            www.scriptcase.eu / www.scriptcase.nl

                            Comment


                            • #15
                              I use Javascript to get rid of that. Find the ID of the label or element using "Inspect Element" on Google chrome.
                              Do this by right clicking the ID label when viewing your form, click "Inspect Element". Find the Element ID of the ID label.

                              Put this in your Javascript section under 'onload' event form.

                              Code:
                              document.getElementById("your_element_id").remove();
                              Your element id label will look something like this: "id_ajax_label_NameOfField"

                              This will will remove the ID field from the form, leaving only the username field!
                              Last edited by mikelaw; 12-04-2014, 11:17 AM.

                              Comment

                              Working...
                              X