Hello,I am new here and am trying to find a way to create a new record (and auto-populate some data into this new record) when the user pushes a button on a different table.Example:I have table A and table B. I want to find a way whereby if the '2024...
Hi,I am trying to create a simple IF Statement to produce the result PASS or FAIL if the value in another column is >= 80%: In Column 1 ('% germination rate on second check') are % figures with values ranging from 0% to 100%. The purpose of the Colu...
Thanks Databaser, I can see that I can add the fields to table B as part of the 'create record' step, but I am wondering if I can pull the relevant values across from table A into my new record in table B. Do you know if this can be done? I effective...
I think I've figured it out by changing my formula to: IF({% germination rate on second check}*100 >= 80, "PASS", "FAIL")but I don't fully understand why?!
Hi @Sho , Thanks for you reply. I am a beginner here and I don't follow what you're saying. Would you be able to explain? Or offer an alternative formula that may work if your logic is correct? Thanks so much for the support! Z
