| Function Name | Description | Details | |
|---|---|---|---|
| Excel_DocProp | Create EXCEL document properties XML stub. OBSOLETE - New Excel functions in 1.7.8.2 | EXCEL | ► |
| AnnualReport_DemoFurnitures | Full package with report generation to Excel, adding 3 different chart types to the report. Stacked column and line-chart on sheet 1, 2 and 3. Multiple doughnuts on sheet 4. | EXCEL | ► |
| SaveDataToWEB | Save data from FM applicatin to Web-site rest API | REST API | ► |
| LoadFile | Open file and retrieve its content into text return parameter | BOOTSTRAP | ► |
| SaveFile | Save a text variable to a file, given filename and content | BOOTSTRAP | ► |
| SelectAndGetFile | Open file select dialogue and return the content of the file. The variable $$FileName contains the selected filename | BOOTSTRAP | ► |
| SelectFolder | Select a folder and return its path | BOOTSTRAP | ► |
| DirectoryExists | Check if a folder at a given path exists. | BOOTSTRAP | ► |
| FileExists | Check if a file at a given path exists. | BOOTSTRAP | ► |
| GetFilenameFromPath | Return tha filename from a given full path - i.e. remove the directories. | BOOTSTRAP | ► |
| GetDirectoriesFromPath | Remove the filename part from a full path, and return the directory path | BOOTSTRAP | ► |
| GetExtentionFromPath | Retrieve the file type (extention) from a filename or a full path. | BOOTSTRAP | ► |
| SelectFileOnly | Select a file and return its name. Does not open the file. | BOOTSTRAP | ► |
| SaveFileDialogue | Opens a file-save dialogue, and return the file path selected. | BOOTSTRAP | ► |
| OpenOutputFile | Opens a given file and return a file-handle. | BOOTSTRAP | ► |
| WriteOutputMacFileUTF8 | Write to a file opened with the function "OpenOutputFile", using the filehandle and text to write. Converts CR to LF for Mac files. | BOOTSTRAP | ► |
| WriteOutputWinFileIso8859_1 | Write to a file opened with the function "OpenOutputFile", using the filehandle and text to write. Converts CR to CRLF for Windows, and also converts UTF8 to ISO-8859-1 format used by Windows. | BOOTSTRAP | ► |
| WriteOutputWinFileUTF8 | Write to a file opened with the function "OpenOutputFile", using the filehandle and text to write. Converts CR to CRLF for Windows | BOOTSTRAP | ► |
| NumFormat | Formats a given number with 1000 separators and two decimals. | BOOTSTRAP | ► |
| GetFMDeclFromACF | Parse an ACF function to retrieve the Prototype for calling it. | UTILITY | ► |
| AbsolutePaddingZeroes | Pads a number to have static length of digits | UTILITY | ► |
| JsonEvaluate | Returns the decoded value of a quoted JSON string | UTILITY | ► |
| PaddingFixedLength | Returns a fixed width text string padded with padChar. If len is negative, do left justified text. x | UTILITY | ► |
| acflib_Editor_button | Function to facilitate a button script to edit some content in an external editor. | UTILITY | ► |
| AddAttachement | Add a new record in a table, based on users selected file. | UTILITY | ► |
| newCustomersToBOWC | Save new customers to the Timesheet web-site, | UTILITY | ► |
| EncryptFile | Encrypt a file on disk | ENCRYPTION | ► |
| DecryptFile | Decrypts a file on disk | ENCRYPTION | ► |
| ExtractOrderNumbers | Extract 5- or 6 digit numbers from a text, copied from a spreadsheet or similar | UTILITY | ► |
| checkifprime | Check if a given number is a prime number | MATH | ► |
| NumFormatDec | Format number with 1000 group separator and variable number of decimals | BOOTSTRAP | ► |
| BSBO_SaveDocumentDesktop | Copy a file from the document store to the users desktop or a save location. | BOOTSTRAP | ► |
| GetPlatformString | Get Mac or Windows string dependent of plattform it is run on | BOOTSTRAP | ► |
| Save_Logg | Saving logg files in case of application events, or for debugg purposes. | BOOTSTRAP | ► |
| Append_Logg | Append logg to a previously created log-file. | BOOTSTRAP | ► |
| AddMod10 | Add Modulo 10 (Luhn Algorithm) control digit to a string of numbers | BOOTSTRAP | ► |
| AddMod11 | Add Modulo 11 (Luhn Algorithm) control digit to a string of numbers | BOOTSTRAP | ► |
| VerifyMod10_len | Verify Credit card numbers, etc, luhn, modulo 10 | MATH | ► |
| CalcAnnuityInterestRate | Calculate effective interest rate for annuity loan | FINANCE | ► |
| ImportVCFcard | Import a VCF card and convert to JSON | UTILITY | ► |
| Build_Search_index | Build Google search index for a web site | WEB | ► |
| GenSiteMap | Generate sitemap XML for a site | WEB | ► |
| MoveImages | Move images in Markdown document to images folder and rewrite image urls | WEB | ► |
| isLightColor | Calculate if color is light or dark | UTILITY | ► |
| Hex2Dec | Convert hex value to decimal | UTILITY | ► |
| Dec2Hex | Convert from Decimal to Hex value | UTILITY | ► |
| base64ImageTag | Retrieve an base64 image tag from a file | WEB | ► |
| EasterSunday | Calculate the date of the Easter sunday for a given year. | UTILITY | ► |
| NorwegianHolidaysEN | Creating a JSON array with Norwegian holidays | UTILITY | ► |
| EmbedHTMLImages | Embed images in HTML document as Base64 image tags | WEB | ► |
| DisplayBytes | Convert bytes count to short with measurement units. | UTILITY | ► |
| NorwegianHolidaysENJS | Creating a JSON array with Norwegian holidays | UTILITY | ► |
| NonBusinessHolidays | Calculate number of holidays that fell on regular working days between two dates. | UTILITY | ► |
| BusinessDays | Calculate the number of business days between two dates. | UTILITY | ► |
| CalcDueDateInvoice | Calculate due date of an invoice, ensuring it is not on weekends or holidays. | FINANCE | ► |
| DaySalaryFixedPayment | Calculate day-salary for an emplyee with fixed salary. | FINANCE | ► |
| FormatElectronicComponentValue | Sortable electronic component value conversion | UTILITY | ► |
| DisplayEngSciFormat | Convert numeric values into engineering format or scientific format | MATH | ► |
| DisplaySMDCompValue | Convert 3- or 4 digit SMD component value to readable format | MATH | ► |
| DiscountCalc | Calculate Discount Amount | FINANCE | ► |
| GetDependencies | Get a comma-separated list of ID's for dependencies | UTILITY | ► |
| getContaBaseURL | Get the CONTA API base URL, Sandbox or production URLs | CONTA API | ► |
| getContaOrganizationID | Get the organizetion ID @ conta to apply in other API calls. | CONTA API | ► |
| ValidateAndCleanPhoneNumber | Clean phone numbers, ensure it is 8 digits. | CONTA API | ► |
| getContaApiKeyandNumber | Retrieve the Conta credentials used in the API | CONTA API | ► |
| ContaMakeCustomer | Create a customer in Conta | CONTA API | ► |
| ContaCreateProduct | Create a product in the Conta Accounting System | CONTA API | ► |
| ContaVerifyAPIresponce | Look for error message in Conta API responce | CONTA API | ► |
| assert | Verify of the two parameters are identical, otherwise throw an exception | UTILITY | ► |
| CreateInvoiceDraft | Create an invoice draft in CONTA based on a Order in FileMaker | CONTA API | ► |
| find_in_array | Find an item in an ACF array | UTILITY | ► |
| CreateContaInvoice | Create an invoice in CONTA, and send it. Based on FileMaker front-end. | CONTA API | ► |
| AssertInArray | Function to assert that a given value is contained in a supplied array. | UTILITY | ► |
| find_in_arrayInt | Look up value in an INT array | UTILITY | ► |
| ContaInvoicePayments | Import Payments from Conta and link it to Orders in FM system | CONTA API | ► |
| CallChatGPT | An experimental ChatGPT integration | REST API | ► |
| CreateAiJSON | Generate a parameterized request object with the standard OpenAi parameters | OPENAI | ► |
| SendChatRequestMailDialogue | Complete Chat function to be built into an e-mail client having chatGPT assist in the mail composition. | OPENAI | ► |
| ScanDefenitions | Extract references in an ai-prompt, to generate ref abstracts | OPENAI | ► |
| emailServerPar | Create a JSON object with the server config for use in E-mail sending. | ► | |
| AddAttachement | Select an attachement file to an EMAIL and insert into the Attachement table | ► | |
| FileGetContent | Read content of a file, return its content | ► | |
| FilePutContent | Write some content to a file | ► | |
| PreviewMail | Create HTML version of an Email text stored as markdown format. | ► | |
| Editor_button | Save or load back Markdown content to OS file, for use with Editing in external editor | ► | |
| SendMail | Send Email function | ► | |
| ResizeImage | Resize an image. Uses ImageMagic to resize high quality resizing | UTILITY | ► |
| AIfetchImages | Ask DALL•E•3 API to get an image based on descriptiom, update image tag in document. | OPENAI | ► |
| ProduceSoundFromText | Use OpenAI TextToSpeach API to produce a sound file from a text | OPENAI | ► |
| GetCookies | Get Cookie headers after HTTP request to use in subsequent requests | WEB | ► |
| GetNameFromPath | Retrieve filename part from a full path | UTILITY | ► |
| FormAttachement | Create File Part for multipart/formdata API request | REST API | ► |
| FormField | Create field part in Multipart/Formdata request | REST API | ► |
| resizeAndConvert2PNG | Resize an image to a sqare PNG image, 256, 512 or 1024 pixels wide, compatible with DALL-E-2 | OPENAI | ► |
| getImageSize | Get image size, return as JSON object | UTILITY | ► |
| sendRequestImageEdits | Send a request to the image/edits openAI endpoint. Doing image edits. | OPENAI | ► |
| OpenFolderInFinder | Open a file-system folder in Finder | UTILITY | ► |
| OpenFileInExcel | Open a given file in Microsoft Excel, independent of default binding. | EXCEL | ► |
| SetDefaultExcelStyles | Set up default styles for your spreadsheet production | EXCEL | ► |
| SampleExcelDoc | Generate a sample Excel Spreadsheet | EXCEL | ► |
| CountLines | Count number of lines in a text string | UTILITY | ► |
| ExportACFlibList2Excel | Export ACF-Library to Excel | EXCEL | ► |
| TestEditExcel | Alpha-test function to test import/export Excel documents. | EXCEL | ► |
| addMonthToDate | Add month to date. If startdate's day number is bigger tham the target month, adjust to last day in month. | EXCEL | ► |
| AdjustWorkDays | Adjust a given date to the next working day (Monday-Friday) | EXCEL | ► |
| AdjustWorkAndSaturays | Adjust a given date to the next working day if Sunday | EXCEL | ► |
| NextTransRepeat | Calculate the next date (>= minDate) for a recuring transaction. | EXCEL | ► |
| DefineStyles | Define the styles used in the cash-flow demo spreadsheet. | EXCEL | ► |
| GenerateExcelBudget | Main function to produce the Excel budget shown in the demo app for cash flow budgets. | EXCEL | ► |
| GetJsonArrayS | ACF function: get an array from a JSON object into an regular array. | UTILITY | ► |
| InsertNewRow | Insert new row in CashFlow budget demo application | EXCEL | ► |
| UpdateExcelBudget | Update function for the Excel CashFlow App | EXCEL | ► |
| FindSheetName | Searches the sheets in a workbook for a sheet name, and returns it sheetID | EXCEL | ► |
| FindDataRow | Locates a specific label in the first column (column A) of a given sheet. | EXCEL | ► |
| MoveFileToBackupLoc | Rename file to a backup name, finds an unused name to rename to. | EXCEL | ► |
| vlIntersection | Return the intersection between two value lists | UTILITY | ► |
| vlDifference | Return the difference between two valuelists. | UTILITY | ► |
| vlUnion | Returns all unique values from both "SetA" and "SetB". | UTILITY | ► |
| NormalizeCRs | Replace CRLF and LF to CR in a string (Value list) | UTILITY | ► |
| GetCityCoordinates | Return the geo coordinates for a given city or address | REST API | ► |
| HaversineDistance | Calculate the surface distance between two pair of coordinates of the globe | MATH | ► |
| GenJWTtoken | Create and sign a JWT token for use in API-authentication | REST API | ► |
| DemoGetSQLdata | A short demo to demonstrate the named placeholders and the INTO statement in ACF-plugin SQL. | SQL | ► |
| LocalizedDate | Convert at Date or Timestamp value to a localized string | TRANSLATIONS | ► |
| DragAndDropOptions | Create Option JSON object for use with the new Drag & Drop functions in the ACF-Plugin 1.7.7.4, now 1.7.8.2 is available. | UTILITY | ► |
| RetrieveDataFromExcel | Return a two-dimensional JSON array from the content of a Excel Spreadsheet | EXCEL | ► |
| MakePlatformBannerImages | Full package for adding plattform banners overlay on product images. Uses ImageMagic | UTILITY | ► |
| AnnualReport_DemoFurnitures | Full package with report generation to Excel, adding 3 different chart types to the report. Stacked column and line-chart on sheet 1, 2 and 3. Multiple doughnuts on sheet 4. | EXCEL | ► |
