nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confiform 'Lookup and Set Value' is not refreshed in table view

Peter Baschan

Hi,

I have two forms:

- 'ProjectUpdates' to capture project updates with fields: Project (Dropdown), and Update (TextArea)

- 'ProjectList' to show project data with fields: ProjectName (Text), JiraLink (Jira link), and LastUpdate (lookup from 'ProjectUpdates' using sort by 'created' DESC and Limit to 1 result

In the TableView for 'ProjectList', when I add a new project, it pulls through the last update from the 'ProjectUpdates' form nicely. However when I add a new entry for the Updates form, the TableView for the ProjectList is not refreshed to bring in the latest update. It only updates, if I go and Edit the ProjectList entry, it brings in the latest update, so without changing anything, I press Save and the table is now showing the correct last update.

A simple page refresh is not enough, I have to physically open the entry for editing, to get the looked up field refreshed.

Is there a way to make the TableView refresh automatically, so the lookup brings in the latest update?

Thanks,

Peter

Accepted answers

Alex Medved _ConfiForms_

With a "lookup and set value", you copy it from the place where you have looked it up from

(the value represents the copy of the value at this time the lookup has been made)

Alex

All comments

Alex Medved _ConfiForms_

With a "lookup and set value", you copy it from the place where you have looked it up from

(the value represents the copy of the value at this time the lookup has been made)

Alex

Peter Baschan

Thank you, I understand. Is there any alternative way to achieve the same thing? To show a value from another form based on a set criteria, but the result may be different as time goes on? Kind of like having an 'IFTTT' rule called 'onRefresh'. Thank you.

Peter Baschan

I managed to find a solution using the OnCreated IFTTT with 'Update ConfiForms Entries by Filter' action. Essentially the ProjectUpdate new entry overwrites the field on the ProjectList form.

Alex Medved _ConfiForms_

That could be one solution, another might be to query the field in ProjectUpdate directly using queryAndRender - https://wiki.vertuna.com/spaces/CONFIFORMS/pages/2359385/Virtual+functions

So, you are not copying (therefore no need to look up and set or the field itself), but kind of doing a direct lookup in the view

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

confiforms