Write a calculated value in GLIDE to EXCEL

Ask for Help
1

Good morning community! First of all, Merry Christmas and Happy New Year 2024.

I have a question about GLIDE that may be very basic but I don’t know how to solve it…

I have in EXCEL the database of an application in which I have fields like:

  • product price
  • units of product sold

In GLIDE I make the calculated value of (product price) * (product units sold) = (sale value).

Can I copy said value calculated in GLIDE (sale value) onto a new cell in GLIDE called for example (calculated value) so that it is updated on the EXCEL in the “calculated value” field???

PS: we need it to be reflected in EXCEL to be able to capture the value in the “mail merge” of WORD and to be able to generate PDF of invoices since we believe that being able to create these invoices (PDF)

Many thanks again to the community.

Greetings,
Javier

2

Yes. You’ll want to add a new ‘basic column’ to your table and then set column values of the sale value to the new basic column. Look for somewhere in your flow to set column values.

2 Likes
3

Thank you @Eric_Penn very much for your answer but excuse me but I haven’t quite understood how to do it?
With what GLIDE function can I copy the value previously calculated in GLIDE from the “sale value” column to the new “basic column” created???

Thanks again.
Javier

4

Use an action with Set Column Values.

4 Likes
5

Thanks :wink:

1 Like
6

@Darren_Murphy Thanks,
the use of the GLIDE-ACTIONS functionality works correctly and performs the required action, but it ONLY executes it for one ITEM… and we would need it to be for all the values ​​in said column. Only the “This item” option but I don’t get the “all item” option, is that the case???

Thank you very much in advance.
Greetings,
Javier

image
image3817×1020 149 KB

image
image3835×1675 265 KB

7

Yes, that’s correct. If you need to change values in multiple rows then the best way is to use the Glide API. Although, I do see from your screen shot that the column you are setting is User Specific. It wouldn’t be possible to set that via the API. In fact, I wouldn’t even expect that column to be visible in your connected Excel sheet - Glide does not sync User Specific values to external data sources.

2 Likes
8

Once (sale value) is generated and stored in a Glide table, then in order to have that value stored in Excel, you need to push it from Glide to Excel somehow. That’s seems convoluted compared to generating and storing the value in Excel directly. Have you considered creating a formula in Excel so that (sale value) is generated in Excel directly?

If you want to keep computed values in Glide tables, have you considered the DocsAutomator or PDFMonkey integrations, which allow you to generate PDF documents from values in a Glide table?

2 Likes
9

Thank you @Darren_Murphy for confirming that only Item by Item and your solution proposal via API is possible.

Thanks again
All the best,
Javier

11

@nathanaelb It was really the first idea we had and from Excel it was synchronized in Glide but we intended to try to bring everything from GLIDE so that EXCEL always acted passively and as a backup database only. But we will return to that initial idea :wink:

Thank you very much for your proposed solution.
Greetings,
Javier

1 Like
12

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.