I want to automatically calculate the region, prefecture and commune when I enter ‘college’.
I have the correspondences in cascading list in the ‘choices’ sheet, the names of the regions are recorded with numbers in the ‘name’ column. So in front of each college, in the ‘region’ column, you’ll find the number of the corresponding region
Hi @b7anco,
Use another variable with ‘note’ variable type to show in Apps or Web form. Because ‘Calculate’ field does not show in the Apps or Web. You can visit this link: