Hi
I want to make a field in a subtable that stores the subtable as JSON.
This in order to have a field outside the subtable to make an array of the JSON collections before I send it over to make.com so I save a couple of thousand operations.
But it seems Ragic can not handle JSON objects in textfields? I see them in the beginning, but then the field with the JSON formula gets blank.
The functionality Make.com offers for subtables is somewhat limited. If you want to use the subtable like a regular table, the simplest approach would be to create New Sheet From Subtable.
If you have any further questions, could you please share more about the specific outcome you’re aiming for? What exactly are you trying to achieve?
Hi
The idea was to make a combined json string in ragic (combing subtable + one other field) before I send it to make.com. This to avoid having make.com go over in total 5 modules (and 5+ operation counts) to do this. I now have the solution working via make.com (adding all subtable rows to an array and then adding another field to the array), but would be nice to do it from Ragic instead
If you would like to return a JSON string for the data of a sheet, you can use the module in Make to create JSON. By using certain fields provided by Ragic, you can generate a JSON string, which can then be utilized in subsequent modules, as shown in the screenshot. However, this approach does not apply to subtables, you’ll still need to generate a New Sheet From Subtable.
Yes, it is possible, but it’s a bit complicated as it requires creating a custom workflow. You would need to customize it based on the sheet design, as shown in the sample screenshot.
You can generate the JSON data and update the target field using a post-workflow. Please refer to the Javascript Workflow documentation for more details.
If you need further assistance with the steps, feel free to reach out to us.
