nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Web Service Drop-down - Excel Source (Confiform)

Andre T.

I have created a Web Service Drop-Down to pull data from a specific Excel file. The drop-down field shows the entries pulled from the Excel just fine, but I am having trouble doing a validation lookup against the web service drop down because it is not yet part of my confiform table of data.

Any ideas on how to do a lookup against an excel column without having those entries part of the Confiform table yet?

Accepted answers

All comments

Alex Medved _ConfiForms_

I am afraid you cannot lookup agains the excel file through ConfiForms.

As I am assuming you are using the experimental API we provide to read the contents of an Excel file and that does not provide any support for parameters / lookups

Alex

Andre T.

Hi Alex,

Is it also normal behavior that the column pulled from excel doesn't show up in the preview drop-down window?

Is there an alternative way to pull a column from Excel to a Confiform field? My column from Excel has 1400 rows.

Thanks!

Alex Medved _ConfiForms_

Preview might not work, especially if a webservice uses context variables (and even if it does not I think we dont render in the preview)

What do you mean by pulling the column? You can setup a dropdown and then you can build a view and put a ConfiForms Field macro with a field name set to show any other associated (with row) column from your excel

Assuming your dropdown field is called myfield and you want to show the column 4 form excel

then you put a field name to

myfield.cell4

Andre T.

I am trying to do validation (data set) against that field but it isn't working...

webservice field is called Excel

I am looking to pull second column from Excel and due a Validation Rule (data set) against another column:

Excel.cell2:[entry.field]

Based on user input from "field" should compare against the entire cell2 dataset and provide a message if found. Unfortunately since the entire dataset isn't in the confiform table, this isn't working for me.

Any thoughts?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

ms-excel

confiforms

webservice