This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi there!I've created and automation that does the following when a record getting updated...Watches FIELD A for update (which I do a copy/delete/paste of 50 records to trigger)Finds all records where FIELD A contains FIELD A (identical names)Updates...
I have this formula as 1 of 3 parts that's extracting certain bits of data from a reference cell into 3 adjacent cells. What I'm wondering is if I can add something to get a specific character insert BEFORE the info...Examplereference cell contains :...
Is it possible to limit the number of records syncing from one table to another?For example "Table A" has 15000 records and I want records 1-100 to populate "Table B", 100-200 in "Table C" etc.
I need some help trying to write a conditional formula...The idea is IF any cell in column 1 is duplicative/match entry, then look at corresponding column 2 cells and merge merge into corresponding column 3.Is if A2 and A45 match look at/merge B2 and...
// Define the baseconst base = ('DMB_Data');// Define the table name and column namesconst table = 'DMB_Products_Groups';const columnA = 'email';const columnB = 'full_name';const columnC = 'multiple_emails';// Initialize an empty object to store the ...
Hi there!Thanks for the response. After thinking through your comment I looked around and engineered a solution but am stuck on one part and wondering if it's even possible.Table 23 - is the data.Check Dup = Link between tablesArray_Letter = Rollup ...
Thanks for the input @TheTimeSavingCo! I kept knocking away at it last night and built an automation that works using a "when record is updated" (trigger) "update record" (action) targeting the long text fields to be updated with trigger field value.
