Help

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

Topic Labels: Integrations
486 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