BradElmore
Qrew Assistant Captain
Joined 7 years ago
User Profile
User Widgets
Contributions
Embed Record Form
I have two tables (Table A and Table B) ---- the tables are not related. I would like to embed a specific record from Table B (using the old record form) into a record form within Table A --- Table B -- I have a number field called [Index]. The index field is unique but it is not the key field. The specific record from Table B I would like to Embed into a Table A form is where the Table B field [Index]=1 I assume I would need a URL formula field in Table A -- that has the "Embed as iframe in forms" checked. I need help with creating a formula that grabs the record from Table B where the [Index] = 1 Any advice is appreciated.70Views0likes1CommentFormula Query (Size) - Question
I have created the following Number Formula query in Table A: My goal is to calculate the total records in 5 non-related Tables. The [Table Alais] field represents the Table Alais for the 5 different tables -- and the [AlaisTableFieldID] is my query field. This formula is not working.....any advice is appreciated. Size(GetRecords("{"&[AlaisTableFieldID]&".EX.'"&[Record ID#]&"'}","&[Table Alais]&"))159Views0likes2CommentsRe: URL formula -API_RunImport
Mark, that worked great! I ran into another issue with the formula field below --- This formula involves Two applications - [App A] and [App B] --- From [App A] in [Table B] -- I created a Rich Formula Field (see below) -- My goal is to leverage a "table import" (API_RunImport&ID=38 (38 is my table import id in [App B] -- Import the records from [App A]/[Table B] into [App B]/[Table C] -- and return to the record form I press the "Import Records" button. var text Checkbox = I assume I enter the "[App_B_ID]/" vs "db/". var text RefreshPage = This is where I'm having an issue with my current formula -- the "db" is highlighted in yellow -- stating - A variable statement must end with a semi-colon Thank you again for your help..... Current Formula: var text Words = "Import Records"; var text Checkbox = URLRoot() & "[App_B_ID]/[table_C_ID]?act=API_RunImport&ID=38; var text RefreshPage = URLRoot()&"db/tableid?a=dr&rid="&ToText([Record ID#])&"&dfid=10"; var text URL = $Checkbox & "&rdr=" & URLEncode($RefreshPage); var text button = $RefreshPage; If([Total Records (Trace Table)]>0 and [# of Consolidated Trace records]>0, "<a class=\"Vibrant Primary\"a href=" & $URL & ">" & $Words & "</a>","")37Views0likes2CommentsRe: URL formula -API_RunImport
Mark, I'm using the Rich Text formula field below -- works great -- But I would like to Add a step -- that after running the "run-Import" -- I would like to change a check box field [field d] - to True --- and then go to the "Refresh Page" --- is this possible? var text Words = "Consolidate"; var text Checkbox = URLRoot() & "db/[tableId]?act=API_RunImport&ID=" & [TableImportID]; var text RefreshPage = URLRoot() & "db/[tableid]?a=q&qid=22" & Rurl(); var text URL = $Checkbox & "&rdr=" & URLEncode($RefreshPage); var text button = $RefreshPage;65Views0likes1CommentRe: Pipeline to add Parent record from child import
Mark, I’m working on a process where 15,000 records are being created. However, with the filter I’m using on the trigger (“When record created”) to focus only on records without a parent relationship, the pipeline should ideally only process 8,000 records. The “Custom Key” field is being used to create the Parent records. Here’s the workflow I’m following: Trigger: (8,000 records) When a record is added to the Child Table, filtered to only include records without a parent relationship. Bulk Upsert: Create or update records in the Parent Table using the [Parent Key Field]. Add Row: The [Custom Key Field] from the Child Table is used to create the Parent record in the [Parent Key Field]. Commit Upsert: Commit the upsert to finalize the changes. I just ran the pipeline again, and all four records were added successfully. However, the bulk upsert continues to run even after the Parent record is created. Is there a way to set the pipeline to end after the Parent record is created? For instance, if 2,000 out of the 8,000 records belong to Parent A, the pipeline should stop processing once Parent A is created from the first record, rather than continuing to re-trigger for the remaining 1,999 records. Once Parent A is created, its relationship with the remaining 1,999 records should be established automatically. Could you please advise on how to configure the pipeline to stop after the initial creation of the Parent record? Thank you52Views0likes1CommentRe: Pipeline to add Parent record from child import
Mark, I'm running into an issue -- where the Parent record is not being created -- is there a record limit (for using this pipeline method)? Let's say I have 15,000 records created -- and the pipeline is triggered -- with a filter (on the "When record created") that limits the 15,000 -- down to 8,000 -- out of the 8,000 -- I need 4 Parent records created -- however -- only 2 of the 4 Parent records are created -- any ideas to why? Thank you.134Views0likes3Comments