Check if a row is completed and book a call within a timeframe

Ask for Help
1

Hello,

I’m looking to solve 2 issues.

  1. I want to check if a row is fully completed, how can I do that? I want to display some pages ONLY IF users have completed the onboarding procedure. So how can I check if a row has something inside every field?

  2. I want users to be able to book a call within a dynamic timeframe: if a project is started on monday they can book from tuesday to thursday. If a project is started on tuesday the can book between wesnesday and friday. I can use calendly or directly zapier/calendar

Thank you for your help!

2
  • Add a Make Array column that combines all your fields into an array.
  • Add a rollup column on top of that array.

Then you’ll know how many non-empty fields are there. Say you have 16 fields, you would expect the rollup to be 16 for everything to be not empty. Build your conditions based on that.

Not sure about the other question, maybe you can use a Custom Form to show an error when the chosen time does not fit the timeframe. Also you might want to consider the business days factor. Say the project starts on Friday, then do we limit the weekend and only allow them to book Monday - Wednesday?

1 Like