Completion of the form in percentage to be shown based on form name

[Akshay_patel95]

Hello there,

How can we implement percentage of form completion? There are multiple forms based on questions in it. I want to show completion percentage in deck view How much it is completed. Can anyone help?

[Joseph_Seddik]

Hello Akhay and welcome to the community!

Yes you can! Supposing your questions are in a separate column each named Q1 to Qn, you need to add a new column, Type: Percent, to calculate this percentage. The App Formula of his column can be:

SUM(
  IF( ISBLANK([Q1]) 0, 1) +
  IF( ISBLANK([Q2]) 0, 1) +
  IF( ISBLANK([Q3]) 0, 1) +
  ...
  IF( ISBLANK([Qn]) 0, 1) 
)/n

Where n is the number of questions in your form. 

[Akshay_patel95]

Thank You KJS,

I know this solution. But I want to see the percentage completed in different table.

In Table A, I have Unit, Section. and I will create Percent VC to record %. When I click on the Section it'll open a form from Different table. Let's say FormA from Table B. Now, I want to see completed % formA in Percent VC of Table A.

[Koichi_Tsuji]

I suppose you need to review your data structure first. It is not efficient to have Q1 -- Qn columns.