Direct link to record audit?
Is there a way to create a grid view action that would take me directly to the audit record for a particular item that's clicked on - what would the URL be?
adding currency fields in a formula
This seems like a no-brainer but when I try to add two currencies in a formula field I'm getting a concatenation instead of the sum of the two fields. So, $5.00+$8.00 becomes 5.008.00. Do I need to convert the currencies or something?
Is there a way to invoke a function using <a> tag in html snippet in zoho creator page?
Is there a way to invoke a function using <a> tag in html snippet in zoho creator page?
Lookup field to the same form
Hi, I'd like to create a lookup field that points to the same form where i'm creating the form. Is it possible somehow? I want one record to point to another record in the same form, based on some critierias. Thank you.
Different behaviour when saving record depending on how I open the record editing page
Hello, I've created an app on Zoho Creator and I see a different behaviour depending on how I open the record. 1) If I open the record by navigating the app, edit it and save it: I see a "Data updated successfully" pop-up on the top of the screen and
Conditional Formatting Date parameters
I have a date field that is used for a deadline. I'm using conditional formatting to color the date text red if the date is in the current week. The problem is if the date is past due over a week, the color does not stay red. It reverts back to the normal color if the date is post-dated over a week ago. Is there a condition that says, "if the date is after the deadline, keep it red." I've tried using the "after" condition but there isn't a way to tell it "after" the field date. It only allows a string.
How to get the link /url to an attachment
I need to get the url / link to download files uploaded through the form. this link needs to work for people who are not logged in (i.e public link). Can anyone help ? The old format i found won't seem to work. Thanks!
Filter dropdown lists
How can I filter the data users can select from a drop-down list? Example: A sales person wants to enter a sales meeting it had. He selects his name from a dropdown list and after that he wants to select the company he visited ( he previously entered the company in another form, with all its details ). How can the dropdown list with companies filter only the companies he is accounting for?
Save as Draft Button Missing in Zoho Creator Form
Hi, I already enabled "Save Draft" option in my Zoho Creator form. But when I go to the published permalink, I only see Submit and Reset buttons in the form's footer What am I missing here? I also tried filling the required inputs but still no "Save as
Find all duplicate Names
In a form with many records imported, I need to find and mark (Suspected_Duplicate field ="Yes") all the records with the same Name.
File uploaded - how to attach and send using sendmail
Hi, My form has these fields Document: [upload file] Contact Email: XXX@domain.com When a new record is added, i want the document/file uploaded to be sent to the contact email. i tried to add it into the message using "input.Document". But when i received the email, input.Document just prints the name of the document into the message body. There is no email attachment. Anyone with any idea! This is pretty important to the application i want to build... anyone with any ideas?
Accessing Zoho's Barcode generator?
Is there a way to create an image link to barcode images from Zoho's free barcode generator using and openURL script? I'm doing this using barcodesinc.com's free generator, but would like to try getting them from Zoho's generator. I can't figure out what
Sort list by count (occurance) or character count
Wondering how to sort a list by either occurrence count or character count. I have: toppfs = LP_inventory_form[AUCTION_TITLE_ROOT = input.AUCTION_TITLE_ROOT].Pressing_features.getAll().distinct(); toppfs.sort(true); input.Pressing_features:ui.add(toppfs);
How do I pass data from one form to another form?
hi Zoho creator has 2 forms. First form have name and email. Go to second form after submission. How to view name and email in second form?
"Save & Resume Later" or "Save as Draft" for Zoho Creator Forms
Hi, I am trying to create a form on Zoho Creator with the options of "Save & Resume Later" in addition to "Submit" and "Reset". How can I create that? (I had been a user of Zoho Form and that was a matter of setting, but it seems that there is no such
How much of Creator is Low-Code [a discussion]
The following table is my take on how much of a low-code environment Creator actually is. My takeaway? The minority. I welcome your edits and comments! Record Event Created C Edited E Created or Edited CE Deleted D Hide, Show, Enable, Disable, Set Fields
Approval flow from update
Hi, i'm setting up an approval flow in Zoho Creator. However, it seems it's only triggered when submitting a brand new entry. We have the situation where the entry is already created, but approval is requested when a certain field is updated. Is this
How to auto populate fields based on an entry?
I seem to run into brain fade right when I need the answer most. And when I'm about to go out of town. Thus I'm asking an easy question that I can't find through forum/help searches. I have one form that starts with a radio button with 5 possible choices (called "Team"). The following fields should be auto populated based on the response to to Team: Team_Head_Coach (5 possible values) Team_Coach_Email (ditto) Team_Coach_Phone (ditto) If a new record is being entered and the user choose "Team 1"
How do I find out the user account id from an email ?
I'm creating an employee register by using an API from our HR system (not Zoho People) and I want to link the zoho account of employees to this record. However I can't use the associated email and I can't find a way to get the account id. For example
barcod
pl
How to add and remove fields that can be mapped when importing from Excel
I am trying to import an Excel sheet which will come out of our POS and create an Order Management tool. When I try to import it says I have to map columns, but when I go in to map them, there are "required" fields like "Delivery Agency" which we will
record_summary ID?
How do I get the ID? I have this as an example for a a "comment" I @ mentioned myself on. <SNIPPED>/record_summary/UAS_Aircrafts_Report/3850763000000308019/ How do I get this full URL???
When I am creating a new customer, after filling all necessary details I am getting this error message "Invalid value passed for attention" . I am not able to figure out what is causing this.
I haven't done anything different from other times but not sure why it wont let me save the new customer.
How to use a conditional formula based on a lookup?
Hi, I need a formula that is something like this : if(Test = TRUE, if(Installer.toString() == "Patriot", 1000, 0), 1). However, Installer is a lookup field and zoho doesnt seem to be catching that. How can i make that work?
Adding Subform Row Values together
I am having a hard time figuring out how to add values from a subform together. I have a subform called - Payment_Information When people pay us, I record the payment in that sub form called - Amount_Received. If they pay in full, it's just one line and
Add Days to Calendar
I am creating an Invoice system. I have a field called - Terms, which is a drop-down with four options since I have customers that pay on different lead times. Due on Receipt Net 30 Net 45 Net 60 I have another field that is a date field called - Due_Date.
How do you remove name or account name from Permalink url?
I created a private form I want the public to fill out. So I did a permalink iframe without login. However when I load the iframe and right-click, View Source...my personal name or account name is in the url. How do I remove or change this? Thanks! Robert
Creating country drop down menu
Hi there, Apologies for the incredibly basic question, I'm just starting out building my first form on zoho. I would like to have a simple drop down menu field where the answer options are the standard list of countries. Is there a quick and easy way to do this or do I need to type in each country? Any help much appreciated. Thanks!
Can you make an email update a record in Zoho creator table?
On my application I set up a stateless form "Issue Request" that when the user clicks a button to open issue request it displays the stateless form. The users will then select the email address or multiple address' to send to. Enter the issue type and
What is "Link to view"?
I'm having an hard time finding what the "Link to view" feature does of Zoho Creator: Thank you
Automatically export
Hello, is there a way to automatically export all entries once a day as a csv file and store it in a folder? Alternatively, how can I access the entries of a form in Creator and retrieve them from Creator via Power BI? Best regards Jörg
How to show a report to the admin only in the Zoho creator app and hide it from other users of the app?
How to show a report to the admin only in the Zoho creator app and hide it from other users of the app?
Can I get stock prices in Creator
Is there a way for me to get current stock prices, DayHigh, And DayLow into Zoho Creator the same way as in Zoho Sheet?
Update / Refresh report automatically?
I have 2 forms: newspapers and prices. I have a report of newspapers linked to prices. If I update the price for a specific newspaper in form "prices", I would like to see the price of the existing record in my newspaper report change as well, which is currently not the case. How to automatically refresh the report? Thank you in advance
Single User Subscription
Hi Everyone, I am working as freelancer. I am exploring ZOHO Creator. I am thinking for purchasing single user for my self for practicing. Please guide me whether I can purchase single user for ZOHO Creator.
Zoho Developer Console: How to add developer access
How can I give my developer access to my Zoho Developer Application? I know how to add a developer via Zoho One and/or Zoho Creator, but I cannot do the same thing for the Developer Console...Any ideas? *This documentation was not accurate: https://
Footer needs to be static and be anchored to the same place on every page
The footer needs to be anchored to the bottom of the page - in the same place every time. When I show footer and if my data runs long - the footer shows up on the next page. How do I 'fix' the footer to the bottom of every page in the same place no matter
Multi Page Form
How do I create a multi page form? I am trying to create a web input form that has many fields per record, and I would like to create categories which represent separate pages and have the record persist from page to page until they reach the end of the multi page form and submit it all at once. So for example, I would create a form for "Hotels", and it would include: "General Information" which would include the following fields: Name Location Description Address "Amenities" Pool Spa "Rooms" etc.
Pivot Tables report problem
Hello, I pressed Regenertate on my pivot table report page and now it's stuck for over 2 hours. "Regeneration has been initiated for this report. You will be able to regenerate again when this process is complete" Can you help, please? Thanks,
IOS ‘Tab’ key
I’m currently building a app for customers to fill out their details and there’s a lot of fields for them to go through, they’ll be primarily be using the application on iPads using the creator or customer portal iOS app. I’ve noticed in testing that
Next Page