Read-out from cell in a google spreadsheet

Hello,

The answer depends. How are you reading the Sheet information? If you read the information into a “DropDown DS” field, (for example the fieldname1). You can insert a calculated field in the form, used as an auxiliary (you can hide it by ticking a checkbox in its settings), with the following equation:

IF(fieldname1<=20, 1, 0)

And then, in the settings of the calculated field, you can define a dependency to display the other fields, only if the equation’s result is 1.

More information about dependencies, reading the following post in the plugin’s blog:

https://cff.dwbooster.com/blog/2020/03/01/dependencies/

Best regards.

Hello,

Thank you for your answer! My question is: how can I read the sheet cell info? I can’t figure it out…

Best regards

Hello @migver

The solution would be to publish the Google Sheet document as a CSV file, and use the generated URL to populate the “DS” fields in the form. More information in the following post of the plugin’s blog:

https://cff.dwbooster.com/blog/2019/02/14/ds

Please, watch the following video:

https://wordpress.dwbooster.com/customdownloads/videos/video_ds_google_sheet.mp4

Best regards.

This is perfect, thank you very much!

Also, and a bit off topic: is there a way to “deselect” fields from being exported onto the csv?

Hello @migver

All submitted fields are exported to the CSV files. However, you can decide the fields to submit by ticking the checkbox: “Exclude from submission” in their settings.

Best regards.

Hello again,

That’s perfect, thank you again.

One last question: is it possible for the messages to be automatically loaded into a google spreadsheet file everytime there’s a new submission? I can’t understand if that’s possible with the CV Generator Add On.

Hello @migver

Yes, that’s possible. The following post describes the process:

https://cff.dwbooster.com/blog/2020/06/01/csv-generator-google-sheet/

Best regards.

That’s wonderful! Thank you so much ??

I’ve just purchased the Developer version. Is it possible to get the Platinum version and pay the difference?

Hello @migver

Please, contact us directly through our website: Contact Us

Best regards.

Thank you ??

I’ve just purchased the Platinum version and upgraded the plugin. However, there’s an error:

“Parse error: syntax error, unexpected ‘class’ (T_CLASS), expecting identifier (T_STRING) or variable (T_VARIABLE) or ‘{‘ or ‘$’ in /htdocs/public/www/wp-content/plugins/calculated-fields-form-2/addons/mailpoet.addon.php on line 293”

What shall I do?

Hi! We’d like to help but we can’t reply about that in this forum. We are not allowed to support any customers in these forums.

For pro or commercial product support please contact us directly on our site. This includes any pre-sales topics as well.

Commercial products are not supported in these forums. We will happily answer this and any other questions you can have on our own site.

Thank you.