ammba
Qrew Member
Joined 3 years ago
User Profile
User Widgets
Contributions
Table to Table relationships using a field list
Table 1 has a field called [Notify To] this is a user list (with the user's email address) multiple users can be selected in one record. This table allows to send email notifications to whoever is chosen in [Notify To] Table 2 is for when [Notify To] from Table 1 is out of office. Table 2 has a record for every user list from [Notify To] with a corresponding back up person to send emails when he/she is out of office, also this is the primary key used in Table 2. I have set up the logic when the user is out of office, the back up person will receive the notifications. How do I created a relationship between the two tables using the field [Notify To] if I have multiple users from a record in Table 1? The relationship only works when Table 1 only has 1 user selected. My problem is I cannot connect table 1 and table 2 when the records has 2 or more users selected. ------------------------------ ammba ------------------------------19Views0likes0CommentsRe: User input formula field
Yes, I've tried the dynamic form rules but i'm trying to apply it in the Grid edit mode. I've also added the form under Grid edit (full site) to the "Set how different roles use these forms" but unfortunately this doesn't work either.. ------------------------------ ammba ------------------------------59Views0likes1CommentUser input formula field
Is there a way to create a field/column that is a required field, user input and formula field at the same time (without using automations or pipelines)? The scenario is I have 2 columns: Column 1 is a required & user input field. Column 2 is a formula field. If column 2 has value then column 1 can be left empty OR If column 2 has value, copy value to column 1 only if it is empty (since it is a required field) Or do I not have choice but to manually input a value in Column 1?65Views0likes3CommentsDirectly download a report using a formula button
Is there a way to create/add a button (in a form) that lets the user to directly download a certain report without being directed to the report itself? As of now i've made a button that directs me to the report so i can manually export the report. But what I want is to make the button directly download the report. Is this possible?29Views0likes2Comments