Is there a Maximum number of characters allowed in a URL calculated field?

Hello, 

I'm creating a url that uses tokens to send a bunch of information to a separate website to run some calculations. In all I am pushing over 13 fields worth of data. At about the 6 field point Sugar is no longer writing the fields or the token values. I have increased the max size of the field to a crazy amount like 3000 characters, but I can't get the calculated field part to save any more values or tokens. 

What do I need to do in order to get past this limitation? 

Parents
  • I've created calculated fields with more than 6 fields - how many characters are in the field when it gets truncated? I know the out of the box URL field is 255 characters - and that is at the database level. Is that where you increased the size to 3000?

  • correct. So what ended up happening is I had one account where one of my tokens was really long and the user was unable to save the record. That's when I realized that the 255 characters wasn't enough. I updated that to 500 at the time and was good to go. 

    Here is my calculated formula as it is right now: https://workshop.arvig.com/ROICalculator?roi_type=revenue&selected_drop_down=HPBX&date_of_service={estimation_form_date_c}&salesperson={created_by_name}&customer_name={account_name_c}&customer_address={customer_address_c}&z_location={z_location_c}&project

    What i need is something closer to: 

    https://workshop.arvig.com/ROICalculator?roi_type=revenue&selected_drop_down=HPBX&date_of_service={estimation_form_date_c}&salesperson={created_by_name}&customer_name={account_name_c}&customer_address={customer_address_c}&z_location={z_location_c}&project_management_cost={hpbx_project_management_c}&type_of_service=Hosted-PBX&internet_commit_rate={hpbx_internet_commit_rate_c}&monthly_recurring_revenue={hpbx_monthly_recurring_rev_c}&monthly_recurring_expense={hpbx_monthly_recurring_exp_c}&electric_equipment_cost={hpbx_equip_elect_metalicense_c}&installation_cost={hpbx_installation_expense_c} 

    But every time I save this in my calculated field section it will cut off the remaining part of the formula where it's cut off in the top link.

  • To Do that you can use an html field and from it build the href you can add fields but even so your url is so much data. If you want build an url you can stored in a description field, and you can get the field in a logic_hook after_save and so send her since over there.
    Or you can build an API and get the data and send them since over there.
    Kind Regards.

Reply Children
No Data