ContributionsMost RecentMost LikesSolutionsRe: Limit One Record Per PersonThank you!Re: Limit One Record Per PersonThank you! This option worked and won't interfere with the reports we have already setup for the vote table.Limit One Record Per PersonGood day, I have an app with two tables (employees and votes). I am trying to set it up so that the current user (employee) can only create/submit one vote record. I attempted to create a relationship with a summary of votes, so that I could create a form rule that says if the current user's vote summary = 1, then hide the ADD VOTE button. However, there is not an option to hide the ADD button. Is there something I am missing or is there another way I can set up the app so that only one vote record is allowed per person? Thank you.Problem with if/and/or statementHello, I am trying to build an if/and/or statement that does the following: If record owner = "this role" and checkbox A is "true", then show this generate template button or If record owner = "not this role" and checkbox A is "not true", then also show this generate template button Sample: If([Record Owner]="HR Advisor" and ([HRBP Approval]="true"),[Save & Generate Template], If([Record Owner]=NOT"HR Advisor" and ([HRBP Approval]="null"),[Save & Generate Template])) So far, I am receiving syntax errors and have not been able to build the formula properly. If anyone has any suggestions that would be super helpful. Thank you!Record Owner Form Rule or Formula?Hello, I am currently trying to setup the following as a form rule: If Record Owner is equal to "x" role, and another field contains "x", then show this checkbox. The issue I'm running into is that Record Owner is not allowing me to select from a specific user role. I am thinking this may need to be converted into a formula in order for it to work in the rule? So far, my efforts have been unsuccessful. If anyone has any suggestions as to how I can make this work, it would be greatly appreciated. Thank you!Re: How can I create an IF statement with multiple conditions?Thanks so much!This is exactly what I was looking for and everything appears to be working as intended.How can I create an IF statement with multiple conditions? Hello all,I am trying to create an IF statement with multiple conditions that will return a yes or no depending on if one of the conditions are met. Here is a sample of my formula: If(([Related Candidate (ref) - Job Code])="AACH25,AACH41,ADEV31,ADEV32,ADEV33,ADEV34,ADEV41,ADEV42,ADEV43,"<Font color=RED>YES</font>","null") QB accepts the formula, however, it does not work (I think because it is looking at the conditions as a whole). Do I need to write an IF statement for each of the "AACH25,AACH41,ADEV31,ADEV32,ADEV33,ADEV34,ADEV41,ADEV42,ADEV43" conditions, or can I use OR in between? I have about 320 codes that I need to include so if there's any easier way to do this that would be fantastic. Thank you!