Question & Answer > View Question

How to call value from other table using Javascript API

Confluence User - 03 Jul, 2019

Dear Experts,

var field = FormUtil.getField("field1");

$(field).val("test"); //set value

This Javascript API is what I've been using to call value in custom HTML using Javascript. But this only works when the value is in the same form. How to actually call data from other table in the database. I need to use this to check data existence in the other table.

forms;customhtml;javascript;value;validation;exist;table;database

1

Confluence User •

03 Jul, 2019 •

confluenceUser •

•

confluenceUser •

Hi

You can use Joget hash variables to retrieve the value from another table/form, example below:

var field = "#form.tableName.fieldname[id_value_or_primary_key_value]#";

var field = "#form.tableName.fieldname[{requestParam.id}]#";

More information at https://dev.joget.org/community/display/KBv6/Hash+Variable

1

CSV | Excel | XML | PDF

Your answer

Print

How to call value from other table using Javascript API

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-d4750c1e-7849-4e9b-9163-c16b25d189b8{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-67f9dfee-3b8b-4902-bc7f-031e174a04c3{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer