How Can I Create a Public Form for Clients in a Private Glide App?

[Mateo]

I have an internal app (our CRM) where only authorized users (internal staff) can log in. However, I want to create a public feedback form that I can send to my clients so they can rate the services they receive—without requiring them to log in, as that would create unnecessary friction.

I understand that one workaround is to create a separate public app and link it to the database of my private app. However, my main concern is how to properly link the feedback to the corresponding service. If the **public and private apps have separate databases, can I still use relation columns between them? How would I ensure that the service being rated is correctly associated with the rating and feedback provided by the client?

Also, i would like to send a link to the client, so the link should be linked to their specific service, is that possible ?

Would love to hear the best approach for handling this in Glide!

[ThinhDinh]

@Mateo

I understand that one workaround is to create a separate public app and link it to the database of my private app. However, my main concern is how to properly link the feedback to the corresponding service. If the **public and private apps have separate databases, can I still use relation columns between them? How would I ensure that the service being rated is correctly associated with the rating and feedback provided by the client?

You should have the same tables linked to both apps, assuming they’re Glide tables.

You should store the service ID in each rating/feedback to link them back to the right service.

Glide: Prefill a Form by Scanning a QR Code

You can use the trick here by @Robert_Petitto to prefill the ID (without ever showing it to the front end).