Okay here goes- We have a field displayed as a checkbox set, the data it displays is the lists of services the customers offers, the description also includes the price. They want to be able to click a checkbox or multiple checkboxes per line item & the description & dollar amount appear on that line. I have a script that takes the items that are checked and puts it together on one line by simply using the substitute function, that substitutes the paragraph mark with a comma. Now I just want it to grab the numbers at the end of the description and put it in the amount field.

Example of my list:

Shampoo 15.00

Blow dry 10.00

Manicure 15.00

In this case the amount would be 40.00. The checkbox set is populated based on a pricebook table. They simply check the items for that line item, click and enter button (which performs the script) and it throws all the services on that line, and next I need it to total the amounts for those services checked. Normally in other databases I've done we would select an items number it would populate the description and amount. But they want it like this...

Ideas? am I just missing something?

Thanks for the help in advance!

Caroline

Hi

you could use this calculation:

Evaluate ( Filter ( Substitute ( YourCheckBox ; ¶ ; "+" ) ; "+1234567890,." ) )

... but I wouldn't have those checkboxes to choose a product.

They want to be able to click a checkbox or multiple checkboxes per line item & the description & dollar amount appear on that line.

This doesn't make much sense. Why don't you have a separate line item record for every selected item?