Table View of Self-Join Tables setting default value where no match found

[Durand]

Using a self-joining table to enter part numbers and quantity required to view description, pricing, discount structure etc.

When entering a part number that doesn't correspond with any part number on the stock list (part number and quantity table self-joining to stock list) it will obviously not show any other detail as there is no data to match, but I would like to set a default value for the description field when no match is found to display 'Invalid Part Number'.

I've had some ideas on how to get it done but keep getting stuck as I also want to display this in the Table View with HTML.

Only way I've managed to get near to what I want was to add a cascading autocomplete text field, but I can't hide this field from the table view where the part number and quantities are entered.  I can't think anymore, surely there is an easier way.  I don't know enough of JavaScript, but thought that could be an answer to use an HTML block with javascript to display what I need.

Any suggestions?

[Hastur]

@Durand

Can you provide me with a more detailed description of the workflow you want to implement?
It will be great if you can make some print screens with examples of what you try to achieve.

Looking forward to replying from you.

[BaySunshine]

Hi @Durand,

Is your Description field set as a Cascading text field to show the description of a part number from another table?

If so, I advise you to add a Virtual field and change the form element of this field to 'Calculated value'. Add a Case..When statement as below:

*************

Case when [@field: Part_Number] is null 

Then 'Invalid Part Number'

End

*************

Add a Rule to the DataPage for both the Virtual field and the Description field.

Rule 1: Part number field 'is blank', 'hide' Description field

Rule 2: Part number field 'is not blank', 'hide ' Virtual field.

I hope that helps.

Regards,