Page 1 of 1

Excel Form Uploaded in PAX

Posted: Thu Jun 13, 2019 8:39 pm
by manu0521
Hi Guys,

I have like an excel form created in excel with some basic validations on the sheet and loaded it to paw as a book .

Users will be able to enter the details in the form and I plan to have a submit button which write the value in a TI Process from the sheet in to a attribute cube .

I wanted to know is there a way to have 2 buttons and show the submit button only if all the entries are valid or have one button shown disabled initally and once the users enters all details and is valid enable the button .

Any help is appreciated as this one is new to me .

Re: Excel Form Uploaded in PAX

Posted: Fri Jun 14, 2019 2:15 pm
by Emixam
** I just realize my answer makes no sense to your question, however maybe it will help someone else **

Hello,

I don't think there's an easy way to do that. However, here's my suggestion:

In your Excel form, create a formula to validate if all the entries are valid (0 = No, 1 = Yes). Also, a conditional formatting (0 = red, 1 = green) can be a good way to easily show that not all the entries are valid.

In your TI, add a parameter (i.e., pValidation) and add the following code at the top of the prolog tab :

Code: Select all

IF( pValidation <> 1);
    ProcessQuit;
ENDIF;
You can also play with the Process Option to display messages.

Re: Excel Form Uploaded in PAX

Posted: Fri Jun 14, 2019 2:50 pm
by manu0521
Yes this is helpful . Thanks !! I will give it a try and let you know how it goes.