Skip to main content
Inspiring
February 23, 2024
解決済み

if will i select Item no. from dropdown menu then automatically show description and price column

  • February 23, 2024
  • 返信数 2.
  • 11184 ビュー

Hi Community, I am facing a big issue with Adobe Acrobat. I want to merge 2 MS Excel taps with the same functionality.

I have 5 columns 1. Item no. 2. Description 3. Unit cost 4. Qty 5. Total

I need just the first 3 columns' funtionalites.

 

If I select the "item no.'' from the dropdown column then automatically shows a ''description'' column text (this column should not be another dropdown just 1 line text column) and another column has a unit cost.

Please check my attachment. WHOLE ADOBE ACROBAT MUST BE MOBILE-FRIENDLY.  Thanks

このトピックへの返信は締め切られました。
解決に役立った回答 Ruby35654795blw4
error_2.png

I have successfully easily entered item no. on the drop-down menu but I am still facing the issue of not showing the description and prices. Please check 2 attachment of screenshot

I am adding a simple fillable box in the description and unit cost. do I need also a dropdown menu in the description and unit cost?

I am going to item no. property and go to  'Custom calculation script'  and add the below script

 

var cData = [
{item: "Item1", desc: "Description1", cost: 100},
{item: "Item2", desc: "Description2", cost: 120},
{item: "Item3", desc: "Description3", cost: 150}];


if(event.value !== "Select item"){
for(var i=0; i<cData.length; i++){
if(event.value == cData[i].item){
this.getField("description").value = cData[i].desc;
this.getField("Unit Cost").value = cData[i].cost;
break;}}}
else {
this.getField("description").value = "";
this.getField("Unit Cost").value = "";}

 

 

返信数 2

Participating Frequently
February 23, 2024
Inspiring
February 23, 2024

Hi Community, I am facing a big issue with Adobe Acrobat. I want to merge 2 MS Excel taps with the same functionality.

I have 5 columns 1. Item no. 2. Description 3. Unit cost 4. Qty 5. Total

I need just the first 3 columns' funtionalites.

 

If I select the "item no.'' from the dropdown column then automatically shows a ''description'' column text (this column should not be another dropdown just 1 line text column) and another column has a unit cost.

Please check my attachment. WHOLE ADOBE ACROBAT MUST BE MOBILE-FRIENDLY.  Thanks

Nesa Nurani
Community Expert
Community Expert
February 23, 2024

You need script to do that, and script won't work on mobile devices.

Inspiring
February 23, 2024

what is any method where my client easily see this form on a mobile device? thanks