❤️ Discover Appsense: Your Partner in Streamlined Productivity Solutions. Let us handle the complexity while you prioritize your business growth and harness the power of enhanced productivity.
Our current products include: * Power Reconcile for Microsoft Excel * Power PDF Filler for Microsoft Excel * Power GPT for Microsoft Excel
In step 2, after you converted the range to table and added the new column(Month_Money), then you can put the formula in the 1st empty cell. The formula will apply to the whole column automatically. The formula itself is : =CONCAT(MONTH([@[Date Closed]]),"_",[@[Buyer wire in / Seller Wire Out / Wire Out]]). I hope this helps!
for macOS users, to achieve similar results on macOS, you can use bash/zsh from the Terminal app. Video is here - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0a9Tr5hTEZc.html
In this example, to batch rename files in a folder on macOS, open Terminal, then: 1. cd /Path/to/pdf-files-folder 2. input "for file in *[0-9]*.pdf; do mv "$file" "$(echo "$file" | sed 's/^[0-9]*\.//')"; done" and press enter to run In our case, it is to remove the leading digits and dots from all the pdf files. You can update the script accordingly to fit to your needs. Let us know what you need in the comments and we might be able to help.
Before this new feature release, you have the option to re-arrange Excel Columns to match the order of the PDF form fields. Now with this feature, in addition to the existing approach, you have this new option to map Excel data to PDF field without the need to re-arrange Excel Columns. 👏🏻👏🏻
🎉 🎉 Please check out our newly released feature - Custom Data Mapping. This will make Excel<->PDF mapping much easier! ❤ ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iMuWf8PggrY.html ❤
This custom data mapping feature mainly solves several use cases, including: 1. The PDF Form has many PDF fields, while you only need to populate a few of them from your Excel data; 2. The PDF Form has out-of-order PDF fields. And you want to populate the PDF fields using the order of the Excel Data columns, rather than re-creating the PDF form.
If you're following the example in the video, the N1 Rent Increase Form(tribunalsontario.ca/ltb/forms/) needs to be unlocked, simply drag and drop here(smallpdf.com/unlock-pdf ) to get the unlocked PDF.
Once I complete the in-app reconciliation, I need an Excel data file that includes the list of reconciled entries so that I can upload back inti my ERP's bank register to indicate which transactions have cleared (been reconciled). Is such an downloadable file available?
Hi, thanks for your feedback! I believe this is possible. For example, in the generated report, if you choose the Status=1 in the slicer on the top-left corner, then you can get all the reconciled entries. You can then copy these data rows to upload to the ERP system. Please let us know if that works for you. Or if you're interested, we can connect through online meeting. Our support email: support@power-reconcile.tech.
Hi there, thanks for asking! The pdf file name can be customized, please check out this video - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bQxNT1eqayQ.htmlsi=cRVpSrXKft8rnfYs
This Excel Data-Mapping approach applies to several user scenarios, including but not limited to: 1. PDF Fields is out of order. And you want to Map Excel Data to PDF Fields according to your own order. 2. You have a PDF file with hundreds of fields but you only need to auto fill some of them; The key here is to use the built-in feature to "Generate" a template sheet and then map your own sheet of data to this template using Excel Formula. Find out more in this video tutorial! Please let us know if you have any questions!
The files used in the demo can be downloaded from here, so that you can follow the video and try out this solution: power-reconcile.tech/resources/power-pdf-filler/data.xlsx power-reconcile.tech/resources/power-pdf-filler/Sample_PDF_Form.pdf
📖 Today, we created another video tutorial to demo a solution that ensures the Excel data is managed in an order you prefer, independent of the PDF form's fields arrangement. Please take a look if you're interested. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q2P367GxIf8.html 📗
In this video, we demonstrated a solution, which ensures that our data is managed in an order we prefer, independent of the PDF form's fields arrangement. We hope you like it! If you have any questions or suggestions, please feel free to comment below or reach out to us via email - support@power-reconcile.tech
Great tool, but it does not order the fields numerically from top to bottom. Field 7 the first field on my pdf, thus the tool is useless. If you could change the field older this would be golden.
Hi Brandon, do you mind sharing the PDF form with us? So that we can take a look to better understand your requirements? Thanks! Our email: support@power-reconcile.tech.
Hi Brandon, we just created video to demo a solution that ensures the Excel data is managed in an order you prefer, independent of the PDF form's fields arrangement. Please take a look if you're interested. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Q2P367GxIf8.html
Please check out our newly released feature - Custom Data Mapping. This new option provides our users like you with greater flexibility! ❤ ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iMuWf8PggrY.html ❤
Here's how you can do it: 1. Open PowerShell Press Win + X and select "Windows PowerShell" from the Power User menu. Navigate to the Directory: Use the cd command to navigate to the directory containing the files you want to rename. 2. Use the following PowerShell script to rename the files. Get-ChildItem -Filter '*.pdf' | ForEach-Object { Rename-Item $_.FullName -NewName ($_.Name -replace '^\d+\.', '') }
If you need to support non-latin languages, and you see some characters are not displayed as expected, you can try to use Custom Font. To give it a try: 1. Download a font package that supports your language from Google Fonts to your local machine - fonts.google.com/, 2. Select the .ttf file from the downloaded font package in Step 3 when using Power PDF Filler, as showed in this video. 3. Start the job and check if it matches your expectation.
This is an add-in for Microsoft Excel. You can sign in and start free trial anytime. Get it from Microsoft Store: 👉 appsource.microsoft.com/en-us/product/office/WA200002531??mktcmpid=youtube_2&src=website 👈
Lots of users loved our products, thank you all for the strong support! We're continuing to add new features based on your feedbacks. Recently, we've published 3 new features and grouped them under *Advanced Options* : * Customize Font - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zEL-6vFPesk.html * Customize PDF File name - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bQxNT1eqayQ.html * Create read-only PDF files Please let us know your experience with our products so that we can better support you! Thanks!
👉 Get this newly-released product from Microsoft Appsource - appsource.microsoft.com/en-us/product/office/WA200005545?mktcmpid=youtube_10 👈 This website made it super easy to create Editable PDF Forms and is used in this video demo - pspdfkit.com/demo/pdf-form-fill. There are also other tools that you can use to create Editable PDF Forms. Google Fonts allow you to change the appearance of the text. The font we used is downloaded from here -> fonts.google.com/specimen/Pacifico At Appsense Inc., we create innovative productivity tools for you! If you have any questions or feedbacks, please don't hesitate to let us know! Thank you!
PowerShell used in this video to bulk change file names in a folder: Get-ChildItem -Filter '*.pdf' | ForEach-Object { Rename-Item $_.FullName -NewName ($_.Name -replace '^\d+\.', 'EU - ') }
Hi Syed, Thanks for your interest! You can get it from Microsoft Store: 👉 appsource.microsoft.com/en-us/product/office/WA200002531??mktcmpid=youtube_3&src=website 👈
Hi Liza, Thanks for reaching out! We'd be glad to answer any questions related to Power PDF Filler. In your case, we're guessing you have provided the data in Excel. However, you'll have to go to step2 to select the *new* data range in Excel to include all the 80 rows of Excel data. Please check this video from around 2:06 to see how to select data range. If you have any more questions, welcome to send us email: support@power-reconcile.tech.
Hi there, if you have any questions, please let us know. We'd be glad to help! You can also submit us a direct message here - power-reconcile.tech/#support
❤😮 Thank you very much!.... I have been looking for this technique.... My Boss wants me to reconcile data coming from separate tables.... GOD BLESS.... Thanks a lot..
Hi Vikas, thanks for your feedback! We would like to know more details to understand the issue that you have encountered. Will you please send us some screenshots or video to our email: support@power-reconcile.tech. Thanks again!
Demo Files: power-reconcile.tech/resources/Contoso_Statement.xlsx power-reconcile.tech/resources/Contoso_Statement_Long.xlsx The following applications and platforms are supported: * Excel on Mac (Microsoft 365) * Excel on Windows (Microsoft 365) * Excel on the web