Real-World Feedback to Make AI Tasks More Dynamic and Useful

[Saddam]

Dear AppSheet Team,

We’re excited to explore the newly released AI Task feature in AppSheet. After experimenting with it, we’d like to share the following suggestions and improvements that would significantly enhance its usability—especially for field-heavy industries like oil and gas and construction:

 1. Dynamic Instructions (User-Written Input Support)

In many use cases, we want to allow end-users to write custom instructions. It would be great if we could pass a LongText field as an additional or primary instruction to guide the AI dynamically during execution.

---

 2. Enum / EnumList Value Selection

When working with Enum or EnumList fields:

• The AI should be able to access the list of possible values (from dropdowns) and

• Select the most relevant option based on the instruction and the available choices.

This would help the AI provide more accurate outputs aligned with app logic.

---

 3. Use of Formula in Instructions

There should be support for using expressions or formulas inside the instruction to make them more dynamic and contextual—such as referencing dates, user roles, or other columns for intelligent behavior.

---

 4. Output Support for HTML / Markdown

It would be incredibly helpful if the AI could return output in HTML or Markdown format, especially for LongText fields.
This would improve readability and allow formatting like:

• Bullet points

• Headings

• Bold/italic highlights
  Perfect for descriptions, summaries, or reports.

---

 5. File Input Support (Video, Excel, CSV)

In our industries, video analysis and structured file input are crucial:

• The ability to upload a video (e.g., of a safety incident or process) and have the AI generate a brief, structured description would be a game-changer.

• Reading Excel/CSV files would allow extracting tabular data, observations, or logs directly into the app.

---

6. Reading Referenced User Tables (Role-Based Assignments)

Often, we need to assign tasks based on user roles. For example:

“Assign this to someone with the ‘Driver’ position.”

If AI could look up user tables, filter based on roles, and assign accordingly, it would allow seamless integration of decision logic into task assignment.

---

We believe implementing these features will make AI Tasks far more flexible, powerful, and enterprise-ready. Looking forward to seeing these capabilities evolve!

Best regards,
Saddam Hossain
AppSheet Expert
Dubai, UAE
@saddam24k


@Jana_Mandic 
@amyplin 
@lizlynch 
@nico 
@ShirleyN 
@goannsplain 
@zito 
@Roderick 
@Lauren_vdv 
@Arthur_Rallu 

*I encourage everyone to upvote this and help bring these improvements to reality!

[WillowMobileSys]

Since the new AI feature has been opened for Preview and to get the best consideration, you would want to post this in that thread found here:

https://www.googlecloudcommunity.com/gc/Announcements/Gemini-in-AppSheet-now-in-Public-Preview-for-E...

Some of the items listed are not AI specific and should be added to the Feature Ideas list or, if there is already an item list, voted on and any pertinent comments added.  For example, I believe there are probably several items concerning support for video files.

I hope this helps!