ContributionsMost RecentMost LikesSolutionsRe: Is there a way/workaround to create chart on summary report? Bringing this thread to the top. I have the same question. Is there a way to create chart from summary report? ------------------------------ Bibhav Rimal ------------------------------ Re: Pipelines and Sandboxes Anything I should take into consideration before creating the copy of an app? Do all the automations get copied when I create the copy of an app or do I have to recreate all of them? ------------------------------ Bibhav Rimal ------------------------------ Re: ALM Table-to-Table Imports Alternative Solution If I create a pipeline for the same automation and activate sandbox, will I get the same error message? Do you know? ------------------------------ Bibhav Rimal ------------------------------ Re: ALM Table-to-Table Imports Alternative Solution Bringing this thread to the top. I am also experiencing the same issue. Whenever I activate sandbox, the automation that has Table to Table import action step in the live app throws out the below error message. API not allowed when ALM is enabled, ALM production application cannot import data from one table to another. I need to be able to turn on sandbox for a long time without affecting the live app. What is the workaround for this issue? ------------------------------ Bibhav Rimal ------------------------------ Re: Automation to pipelinesSo below is what the automation is doing in the background for the same topic above. I added more parts and quantiles later. Originally there were 20 steps. It is just creating new parts and quantities, 49 in total. is there a way to optimize the steps to below 26? # Add on - Created # # .. Migrated from automation (f328a7da-5e60-47d5-a4c9-894b04db4931) # # Account slugs: # - quickbase[P326pA]: QB Automation To Pipeline <None> --- - META: name: Add on - Created description: .. Migrated from automation (f328a7da-5e60-47d5-a4c9-894b04db4931) tag_names: - Migrated from Automations - TRIGGER quickbase[P326pA] record on_create -> a: inputs-meta: export_fields: 56,54,42,60,61,62,63,64,65,66,67,68,34,53,25,26,27,20,19,28,29,40,41,3,8,59,14,51,39,38,15,58,55,18,31,30,37,36,35,52,33,32,57 query: '{''6''.EX.''Created''}OR{''109''.EX.''true''}' table: '"Scaffold App: Activities" <brijmuz5i>' - ACTION quickbase[P326pA] record create -> b: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_1}}' quantity: '{{a.quantity_1}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> c: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_2}}' quantity: '{{a.quantity_2}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> d: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_3}}' quantity: '{{a.quantity_3}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> e: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_4}}' quantity: '{{a.quantity_4}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> f: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_5}}' quantity: '{{a.quantity_5}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> g: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_6}}' quantity: '{{a.quantity_6}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> h: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_7}}' quantity: '{{a.quantity_7}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> i: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_8}}' quantity: '{{a.quantity_8}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> j: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_9}}' quantity: '{{a.quantity_9}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> k: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_10}}' quantity: '{{a.quantity_10}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> l: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_11}}' quantity: '{{a.quantity_11}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> m: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_12}}' quantity: '{{a.quantity_12}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> n: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_13}}' quantity: '{{a.quantity_13}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> o: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_14}}' quantity: '{{a.quantity_14}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> p: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_15}}' quantity: '{{a.quantity_15}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> q: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_16}}' quantity: '{{a.quantity_16}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> r: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_17}}' quantity: '{{a.quantity_17}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> s: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_18}}' quantity: '{{a.quantity_18}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> t: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_19}}' quantity: '{{a.quantity_19}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] record create -> u: inputs-meta: export_fields: 7,14,16,30,31 table: '"Scaffold App: Build Parts" <bqjqhqtyv>' inputs: add_on_dismantle_id: '{{a.add_on_dismantle_id}}' part: '{{a.part_20}}' quantity: '{{a.quantity_20}}' related_activity: '{{a.id}}' related_build: '{{a.build_record_id}}' - ACTION quickbase[P326pA] bulk_record_set delete_by_filter -> v: inputs-meta: query: '{''7''.EX.''''}' table: '"Scaffold App: Build Parts" <bqjqhqtyv>' ... ------------------------------ Bibhav Rimal ------------------------------ Export YAML from automationHi, Is there a way to export YAML from an existing automation? I know we can import YAML from an existing pipeline. ------------------------------ Bibhav Rimal ------------------------------ Re: Query that determines the Maximum number in a set of records.There should be Max function. Hope this helps. ------------------------------ Bibhav Rimal ------------------------------ Re: Report Formula: Sum totalThank you both. Summary report solved the problem. ------------------------------ Bibhav Rimal ------------------------------ Re: Report Formula: Sum totalAny help on this would be appreciated. ------------------------------ Bibhav Rimal ------------------------------ Re: Report Formula: Sum totalI tried using this formula in excel by downloading the report and it works. The Max function in Quickbase doesn't work for me. =MAX(SUM(F2:F2205)*60)/(SUM(E2:E2205)) ------------------------------ Bibhav Rimal ------------------------------