SC6: ID showing with the descriptions {URGENT HELP}

Applications Forms
#1

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

#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

#4

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

Hello,

Remove the ID from your select statement.

E.j.

Current Statement:

SELECT ID, Country 
FROM Country 
WHERE ID = {SomeField}

New Statement:

SELECT Country 
FROM Country 
WHERE ID = {SomeField}

Notice that the ID is not on the selected fields anymore.

regards,
Bernhard Bernsmann

#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

#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. :slight_smile:

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

jsb

#7

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

Hello,

Have you tried unmarking “Use lookup to display field description”.

regards,
Bernhard Bernsmann

#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 :frowning:

any help…

#9

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

Can you set the id field disabled? Somewhere near the label radio button.

#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 :frowning:

#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?

#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

#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

#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.

#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.

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! :smiley:

#16

Thanks to both Albert and Mikelaw for your suggestions.

I have implemented this with Albert’s way and it is working great.

Very good hint from Mikelaw as well. I’m sure I can use it for something else in the future so will note it down too.

Thanks again.

#17

Need more information.

Can u edit the field in sc and capture the screen?

Dave

#18

[QUOTE=aari77;30133]Thanks to both Albert and Mikelaw for your suggestions.

I have implemented this with Albert’s way and it is working great.

Very good hint from Mikelaw as well. I’m sure I can use it for something else in the future so will note it down too.

Thanks again.[/QUOTE]

Yea, can be really useful for getting rid of the delete checkboxes for the multi-upload field.