I have an appsheet embeded in a custom crm "web embed" component. The CRM is user sign in. The appsheet app is open. In the crm I have the url of the appsheet app dynamical changing to include the crm user id as a parameter in the url. Example: "https://www.appsheet.com/start/{appsheet_app_id}?userid={dynamic_crm_user_id}"
When i open a new form I would like to extract the {dynamic_crm_user_id} and put it into a field in the form. If that is not possible on the first try I would like to be able to extract the entire url which has the {dynamic_crm_user_id} in it, and then parse it out in later columns. I have tried using ai with this for days and nothing. Any suggestions for an app formula for a field or an initial value expression for a field. I am a no coder so please easy on the tech terms : - ) and Thank you very much for your time in advance!
LinkedIn
Twitter
