ContributionsMost RecentMost LikesSolutionsRe: Convert number to decimalThanks, some modifications but works! ------------------------------ Del ------------------------------ Re: Convert number to decimalThis would be a formula text field? ------------------------------ Del ------------------------------ Convert number to decimalLooking to have a field on a form that can accept an entered fraction 1/8, a percent entered as 25%, Decimal .05 or an integer and have it display as a decimal in any case. Do I create a separate formula field? ------------------------------ Del ------------------------------ Re: Formula FieldsAhh it works now when I just typed the formula directly into the formula box rather than pasting it. Interesting ------------------------------ Del ------------------------------ Re: Formula FieldsHere is the formula IF( [Service Type Authorization Description] = "Agency Hired Respite", "Empower U. Services Corp", [Service Type Authorization Description] = "Intensive In-Home Clinical - Licensed Level" AND [Authorization - Responsible Payer] = "Medicaid", "Clinical Care LLC", [Service Type Authorization Description] = "Intensive In-Home Clinical - Masters Level" AND [Authorization - Responsible Payer] = "Medicaid", "Clinical Care LLC") ------------------------------ Del ------------------------------ Re: Formula FieldsYes it is formula Text, still giving me that error ------------------------------ Del ------------------------------ Re: Formula Fields ------------------------------ Del ------------------------------ Re: Formula Fields Getting error related to "AND" ------------------------------ Del ------------------------------ Formula FieldsI am in need of a formula with a few conditions. See criteria below If [Service Type Authorization Description] = 'Agency Hired', then [Providing Agency] = "Airplane Services", [Provider ID #] = 12345, [Provider Tax ID] = 5555, [NPA #] = 5555 If [Service Type Authorization Description] = 'Flight 10' OR 'Flight 11' AND [Responsible Payer] = 'Paid', then [Providing Agency] = 'Jetplace Services', [Provider ID #] = '6789', [Provider Tax ID] = 6666, [NPA #] = 6666 Formula Text Fields; Providing Agency Provider Id # Provider Tax ID NPA # ------------------------------ Del ------------------------------ Location captureLooking to capture the location (via a map) of the user upon selection of a dropdown field. ------------------------------ Ermias Bean ------------------------------