KyleMcAfee

Yes, thank you. I will give that a shot.

I have a list of shippers and consignees and I need the user to select 1 shipper and 1 consignee and save this value into the cargo table. There is aprox 3000 different address to pick from for each field (shipper and consignee). How do I do a multi column look up. I read someones post that mentioned making a formula field that adds customer, city and state. I did this and it works but I can not get this field (calculated) to be used as an autocomplete in the dataform. Basically the forms do not allow you to bring over calculated fields. Work around?

MeeKeee, Each record will ask user if they want to enter data as US Standard or Metric. If they choose Metric, then I want the database to canvert the metric number to us standard and save results into new field as weight_lbs. This needs to be done for Langth, Width and Height as well. The system will convert the MM to Inches and save in length_inches. But some users will be using us standard as input so those numbers will not be converted but simply safe the same amount into weight_lbs or langth_inches. From your other reply sounds like field type list string is not the field type I should have used.

I would like the user to be able choose metric or US standard before they enter numbers for weight and size. but I want the system to show only us standard for outputs on reports. When user chooses metric, I want the system to show us standard weight in field weight_lbs. I thought maybe the list - string field type was wrong choice but I thought it looked like the closest field choice from the available field types. All the errors always show "syntax error at (." What is best way of doing what I am trying to do? Kyle McAfee Kyle.McAfee@BOSScrane.com 812-416-8964

What is wrong with this formula? Very new, so any help will be appreciated. CASE WHEN [@field:unit_of_measure] = 'Metric' THEN [@field:weight_lbs] = 2.204 * [@field:weight] ELSE [@field:weight_lbs] = [@field:weight] END *********** [unit_of_measure] is list string [weight] is number [weight_lbs] is number Need to save [weight_lbs] with the weight after converting from metric if needed, if not needed then just save the weight to [weight_lbs]

Good afternoon. Very NEW to Caspio and having a hard time with a formula. Please review the formula below and let me know what I am doing wrong. CASE WHEN [@field:unit_of_measure] = 'Metric' THEN [@field:weight_lbs] = 2.204 * [@field:weight] ELSE [@field:weight_lbs] = [@field:weight] END Fields Used: unit_of_measure is a list field with US Standard and Metric as the list weight is number weight_lbs is number Any help would be greatly appreciated. Kyle McAfee 812-416-8964 Kyle.McAfee@BOSScrane.com