Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Sep 18, 2020 12:05 PM
I am trying to create a duplicate table in the same base with few records.
I have used trigger actions and trial run was tested successfully.
trigger( a new record created in s_table in base_1) to action( create new record in s2_table in base_1)
the s2_table has custom modifications so that the records to integrate it to Hubspot via zapier.
.
The only change in the field type from original to duplicate is primary services ( multiple select ) and primary services ( multi line text in s2 table).>> reason( for Hubspot integration)
I will appreciate it if some one help me with the automation issue?
Dec 10, 2020 11:02 AM
Something like this is usually possible because Zapier
can read Formula fields:
s_table
base_1s2_table
, Create a Formula column and use ARRAYJOIN({Primary Services}, ', ')s2_table
, Create a Formula column and use ARRAYJOIN({Secondary Services}, ', ')Zapier
at the new Formula fields…Yes, it is a little hacky… but really if you haven’t found a workaround to this since your original post date… what have you got to lose? :grinning_face_with_sweat: