• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Fillable PDF Formula/Function

New Here ,
Aug 25, 2023 Aug 25, 2023

Copy link to clipboard

Copied

Fillable PDF Formula/Function

Hopefully, someone out there can help me out with this. I have been racking my brain and googling away and can't seem to find this formula/function ANYWHERE!

 

I know what the function/formula is in Excel, but I can't figure out how to do it in the fillable PDF.

 

Excel Function: MRound (ADDCELLHERE/2,12)

 

so I'm looking to MRound the number in the specific cell, divide it by 2 but convert it to the closest multiple of 12. If that makes any sense? 🙂

TOPICS
Adobe Sign forms

Views

235

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 25, 2023 Aug 25, 2023

Copy link to clipboard

Copied

I need to upload a document with text tags to get pricing from a supplier.  The returned document will be part of a Power Automate flow to get internal approval for the prices the supplier provided and then update our internal files with the new prices.  During the signing process the supplier will enter the price per case which is a required field.  Then calculated fields will enter the qty per case and the cost per 1000.  I can't seem to make this work.   On one of the support docs I read that advanced form fields and functionality must be enabled on my account.  Included in my Adobe plan is Enterprise PDF Services Developer, PDF Services, Acrobat PDF Pack.  Is the problem due to not having the fuctionality enabled in my adobe account or am I missing something in the syntax of the text tags?

 

Here's what my document looks like:

ProductProduct_DescriptionPRICE PER CASEEA PER CASEPrice per 1000 EA
Item#1Item#1 Description{{$cpf1}{{$csf1}}{{$pptf1}}
Item#2Item#1 Description{{$cpf2}{{$csf2}}{{$pptf2}}

 

Then on another page of the file I have:

{{#REMOVE_PAGE_FROM_OUTPUT}}  
   
{{#cpf1=*cpf1_es_:signer1:format(Number,"$,0.00"):align(right)}}{{#csf1=csf1_es_:signer1:calc(1500):align(center)}}{{#pptf1=pptf1_es_:calc([cpf1]/[csf1]*1000):format(Number,"$,0.00":align(right)}}
{{#cpf2=*cpf2_es_:signer1:format(Number,"$,0.00"):align(right)}}{{#csf2=csf2_es_:signer1:calc(900):align(center)}}{{#pptf2=pptf2_es_:calc([cpf2]/[csf2]*1000):format(Number,"$,0.00":align(right)}}

 

Here a snip of the signed document where the supplier entered $500 for the Price per case on each of 3 lines. 

Lisa294547841hqx_0-1692988230292.png

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 30, 2023 Aug 30, 2023

Copy link to clipboard

Copied

LATEST

I upgraded by account to AdobePro which resolved the problem.  These tags must be what Adobe considers to be "advanced form fields" and not included in the package I was subscribed to.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines