If Else - OpenAI column

[Darren_Murphy]

Okay, I think we are just about there

• Create two if-then-else columns:
  – Call the first one something like ifTeacher
  — If Summary Style is Teacher, then UL_SpeechToText
  – Call the second one ifInterview
  — If Summary Style is Interview, then UL_SpeechToText

Now for each of your AI columns, configure as follows:

• If the column should only run when the Summary Style is Teacher, configure it to use the ifTeacher column
• If the column should only run when the Summary Style is Interview, configure it to use the ifInterview column
• If the column should always run, configure it to use the UL_SpeechToText column.

That should do it, I think.

[Darren_Murphy]

@slscustom.ru

Why you need 2 ai column instead to change AI column parameters by if then else column according style?

That’s probably what I would do - it would mean less columns overall

[Emmett_M]

And IT WORKS , that seems so obvious and simple but you sir , deserve an applause…Thank you!

Not sure what you guys mean about the IF else AI column but feel like I dont want to break anything after just getting this working ha!

Feel free to elaborate though , I might give it a try tomorrow

[Emmett_M]

A nested if else statement rather than multiple IF columns?

[Darren_Murphy]

@Emmett_M

And IT WORKS , that seems so obvious and simple but you sir , deserve an applause…Thank you!

Great! Took us a little while to get there, but we did in the end

@Emmett_M

Not sure what you guys mean about the IF else AI column but feel like I dont want to break anything after just getting this working ha!

Essentially what @slscustom.ru was getting at there (I believe) is that you could have the if-then-else column output the correct AI prompt based on the selected Summary Style, and then reduce the total number of AI columns required.

[Emmett_M]

Ah I see , mission accomplished for today anyhow…I’m sure ill be back at some stage with more questions

Thanks again , very much appreciated.

Good work

[david]

Glide only calculates what it needs to show your screen, EXCEPT when you’re looking at the data editor—then it calculates everything. If you don’t display the results of using OpenAI, they won’t get generated in the app. If the If-Else doesn’t choose the unused prompt completion, it doesn’t get called.

[Emmett_M]

So if I use the visibility function for the frontend to only show a certain column from a row , they will be the only ones that run on the data sheet? Effectively not needing the IF-Else columns then?

[slscustom.ru]

@david

Glide only calculates what it needs to show your screen, EXCEPT when you’re looking at the data editor—then it calculates everything. If you don’t display the results of using OpenAI, they won’t get generated in the app. If the If-Else doesn’t choose the unused prompt completion, it doesn’t get called.

Very, very inportant and usefull comment! Thanks David!!!

[david]

@Emmett_M

So if I use the visibility function for the frontend to only show a certain column from a row , they will be the only ones that run on the data sheet? Effectively not needing the IF-Else columns then?

Yes.