Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

ISO Date in Prefill form and Email with Prefill link to approver not working

Topic Labels: Integrations
732 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rama_Motwani
4 - Data Explorer
4 - Data Explorer

Hi

If I prefill Event Date using the following URL – It dose’nt populate the date in ISO Format. Please suggest.

URL:

Formula used:

CONCATENATE(‘https://airtable.com/shretOBZs7fKCPqk7’,'?prefill_Business+Ticket+Approver+Email=’, {Business Ticket Approver Email},‘&prefill_Event=’, Event, ‘&prefill_City=’, City, ‘&prefill_State=’, State,‘&prefill_Tickets+Requested=’, {Tickets Requested}, ‘&prefill_’**&**ENCODE_URL_COMPONENT ( ‘Event+Date’ ) & ‘=’ & ENCODE_URL_COMPONENT ( {Event Date} ), ‘&prefill_Venue=’, Venue )

Also I want to send the prefill URL to approver for approvals and I configure email automation the Prefill URL is breaking down to this? Please suggest?

https://airtable.com/shretOBZs7fKCPqk7?prefillBusiness+Ticket+Approver+Email=rama.motwani@wwecorp.com&prefillEvent=CMB&prefillCity=Madison&prefillState=WI&prefillTickets+Requested=10&prefillEvent%2BDate=2022-11-13T00%3A00%3A00.000Z&prefill_Venue=Alliant Energy Center

Thanks

Rama

0 Replies 0