Import Radio Button value from Excel into LN Db

HCL Domino Domino Forum
1

Hi,

I am trying to import data from an Excel document into a lotus notes view. It works for all the fields, except the radio button field. The values are either Stop or Go, but when the value in the spreadsheet is set to Stop or Go, it doesn’t set the value in the LN document. Any ideas how I can get around this?

Thanks in advance.

**

While continue = True

	firstField = xlSheet.Cells(x, 1).Value

	If firstField <> "" Then

		Print "Processing doc " & Cstr(count) & "..."		

		count = count + 1

		Set pdoc = New NotesDocument(db)

		With pdoc

			.Form="Import"

			.TmpDate=xlSheet.Cells(x, 1).Value

			.Outcome=xlSheet.Cells(x, 2).Value  **  This is a radio button field in the LN document

			.Value=xlSheet.Cells(x, 3).Value

			.Other=xlSheet.Cells(x, 4).Value

		End With

		Call pdoc.ComputeWithForm(False, False)

		pdoc.Save True, True

	Else

		continue = False

	End If

	x=x+1	

Wend
2

Subject: Import Radio Button value from Excel into LN Db

You could base the radio button on the values of another hidden multivalue field, and fill this field from the spreadsheet.