ZoeGough - profile

ZoeGough · Nov 07, 2023

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...

ZoeGough · Sep 13, 2023

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...

ZoeGough · Nov 07, 2023

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...

ZoeGough · Sep 20, 2023

Ok - I understand. Cool - thanks for your help @Sho!

ZoeGough · Sep 13, 2023

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?!

ZoeGough · Sep 13, 2023

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

User Statistics

User Activity

Using Automation to create a new record and auto-populate certain data

IF STATEMENT not working

Re: Using Automation to create a new record and auto-populate certain data

Re: IF STATEMENT not working

Re: IF STATEMENT not working

Re: IF STATEMENT not working