Create an html button in an html snippet that will invoke a function
On a Page, is there a way to create a button in an html snippet that will invoke a function?
Get Form Access
Hi all , Im working on zoho creator for month , i had a problem in report generating with the count of data in the record submission,I can get choices from record with submitted data but i need show the un submitted choices in the radio fields to the
Add items to dropdown list as new records are added
I would like to add items to a drop-down list as new records are added to my database, as follows: 1. Start entering new record 2. Is the value I want in the drop-down list? If so, select it. If not, select 'Other' and type it in 3. Save record 4. Go to add new record. Click on drop-down list and see the item that I entered in step 2, along with the ones that were there previously. Is that possible? Thanks, Jon.
Converting numbers to text
Dear all, I was trying to convert such an amount to a text string but I couldnt figure it out. Can you please guide me step by step how to handle it? Regards, Nafe
Age Calculation
I've attempted to calculate the age of someone based on their birthday input by using the formula field. It works but I don't want all those decimals on there. I then tried to use "set variable" after birthday input but I get a field type mismatch, long vs. floating. Any ideas would be wonderful.
Duplication Bringing Lookup Linked Records to New Record
Hi All I have a form that is essentially a schedule of courses and dates (which displays these courses on a calendar). I then have a booking form that has a lookup field that is populated with the record ID of the selected course date. This enables me
Zoho Creator : Updating Records via Import. Can't use Autonumber or ZohoRecordID ?
Hi, I am trying to use the function to update a report with an import. I'm running in to the error : "unable to update because the form has no column with unique values" In the release notes it says Only field with unique values can be used to compare
Multiple images
Hi Is there a way to insert multiple images in one image record or any way that instead of one image, I could upload 5 to 10 images together. Looking forward for a solution. Regards
Global variables in Deluge
2023 Release Projection 1 announced Global variables in Deluge for Q1. Was it released?
Integrate SalesIQ into Zoho Creator App
Hi, How can i do that? Or what other possibles do u know to put a chat in a zoho creator page o portal customer?
PDF TO DATA BASE
Hi I am have a PDF document received from a bank and once i upload it in zoho creator i want the data to be stored in the data base . Is there any way to do it
Filter Project List by Owners in Creator
I am able to list all active projects using the following code: zoho.projects.getProjectDetails("myPortalName","active","myConnectionName"); Is it possible to filter this list where Project.Owner inclues a given employee name/ID?
Nested Sub-forms (Subform within subform)
Hi Team, Whether there is any possibilities to add sub-form with in another sub-form like Main Form -> Sub form A ->Sub form B If we tried this, only one level of sub form only working. Any one having any idea about this? Thanks Selvamuthukumar R
Sub form unique entries for specific colum and filtering drop down list.
I have a sub form. One of the fields is a drop down list. I want users to only be able to add a new row with a unique value selected in the drop down list. Ex: Drop down list contains: Red Blue Green A user can add a new record to sub form but can only add Red, Blue, and Green once. For example, they could not add multiple sub form records with Red selected in drop down. I'm just not sure how to check to see if another record has already been added and prevent selecting the same drop down value.
FETCH DATA FROM SUBFORM TO FORM
Hello, I have the form named "Loan application", and another form "Client's transactions" hosting sub form named "Group members." Loan application form has the field called "Account Number" and a sub form "Group Members" has the field called "Account."
How to update image in a Zoho Creator report through widgets (JS API)
I need help with how to transfer an image file from one report to another in Zoho Creator using widgets (JS API). Say I'm fetching a record from the All_Products report. And this report contains a Product_Image field. I then want to transfer this Product_Image
Make a link between 2 reports
Hello, I have 2 search values in my report, one is linked with the target (customer) but the other search value (offer) is not linked with his target. Is there is something special to do to make a link on all the search values ? Thx
How to compare old value and new value on Create/Edit Record
I have a custom module[Project], there is a Lookup Field[Contacts]. I want to change more than 10 Fields from [Contacts] Fields to custom module[Project] Fields when the Contact ID changed. I try to use Automation Workflow Rules Function whenever a [Project]
update new field to a default value on old records
Hi, I would like to add a new field to my forms and automatically update it to a default value on my old, previously created records. I have 100 clients, and I would like to add a flag field on all of them to a default value of "NO", retroactively to all of my clients. I know there is a way to do so without a loop - by using the "required field" functionality. Somehow it worked for me a few months ago, and the fields were well updated. I don't know why, it doesn't work anymore. How do I do
How To Create A JSON Request With More Than One Array Element?
Hi, I am using the postURL functionality. JSON Request body contains more than one array element like shown below, Original JSON Request Body Format To Be Used: { "Name": "Hello World", "Roles": [ { "Profile": "asdf", } ], "Description": "sent" } This is my code used for creating above JSON request using "map()" functionality, myMapData = map(); myMapData.put("Name", "Hello World"); myMapData.put("Description", "sent"); // I used the following code for creating "Roles"
Dynamically set allowed days for a date field
Greetings! Is there a way to dynamically set allowed days for a date field? My application includes a scheduling tool that I need to control what days of the week can be selected based on availability in a provided zip code. For example: Dispatch Calendar:
Another IP blocked by Spamhaus.
Hi, In addition to my other ticket about Spamhaus, the below different IP is also blocked. Our project launces very soon and the sending of scheduled emails it important to the project. Can you please advise? Reason: uncategorized-bounce Message: 5.7.1
How image in a published page show up to external users (when they view the page using the page permalink)
Hi. I have created a page in Zoho creator. This page contains zml snippet which contains line of code for displaying product images from a particular report. What is the syntax I need to use in order for the external users to view these images inside
getting invalid client
getting invalid client
Lookup field in iOS has no search ability
I have a simple form with a lookup field. When I access the form with my iPhone or iPad, the lookup has no search mechanism. It just disappeared! Strangely, when I access the form with another phone using Android, the search appears. Again with my iPhone,
How to Get a List of Radio Button Options or the Index of Selected Radio Button Option in Deluge
Hi, I have a list of radio button questions, each having 3 unique (texts are different) options. For example: Question 1: - This is an answer - Well this is another answer - You could also choose this answer I want to assign scores for each option as
Tip 2: Recursive functions in Deluge: How to dynamically run a function for a specified number of times.
Hi folks, As part of the Zoho Creator - Tips and Tricks series every fortnight, we are back today with a new tip on Recursive functions. Let us first quickly understand what Recursive functions are: A function that calls itself one or more times is known as a Recursive function. That is, you can execute a function to perform a particular action a specific number of times. And, at the end of each iteration, a new output is generated. Recursive functions are commonly used by programmers as it enables
Pass values from stateless form into function
I have a function w/ a list of dates and a list of strings that populates a bunch of data in form1 - it works when executed. I want to use statelessForm inputs dateField and dropDown to populate dateList and genreList in the below function and run it.
Is this hacky solution for admin filtering records in a report safe?
Portal users need to be able to see and edit some records other portal users create. Admins should be able to see and edit all records. I haven't seen any solution that doesn't involve adding some field to every form that is some kind of admin check.
Calendar start time limit
Hi all, Has anyone found a magical way to filter calendar reports to start from, let's say 8:00, and not 0:00? Or at least to auto scroll there like Google Calendar for example?
success message <expression>,<duration>
Hello, I created a Auto Number field to let system auto create a unique number for each record created in a form. Is it possible to a) display this auto generated number at the time user is entering the record, or if not possible b) allow to show to user the auto number within the Success Message once user clicks on Submit button. Your assistance is much appreciated.
Retrieving value from inventory API getRecord gives null
Hi all, I have an issue with my platform I am building. I would like to fetch a list of all my sales orders that are pending shipment from zoho inventory into zoho creator as a list. This is my code for now. When running the script, i get a null value
problem exporting/reporting on Rich Text fields
I have a view based on a form that contains a rich text field. Works fine for editing in the form, but all export options for the corresponding view (PDF, XLS etc.) show embedded html in the text, things like <BR> for line breaks and for spaces. I cannot produce proper output from this view and that is a huge problem! I could convert the field to multiline plain text without a huge loss of functionality, but it's my understanding that Zoho would throw away the data in doing so. That is
Error in syntax parser involving invokeUrl and workdrive upload file
I wasted way too much time and haven't even bothered to get this working yet but it all should be simple after debugging this issue. I see literally no different results between the two syntaxes and have seen no one else talk about this issue but it just
Difficulty retrieving portions of Date-Time object
Having some issues with date-time objects and could use some guidance. I've retrieved a timestamp from a module, in this case the "Created Time" timestamp. The timestamp variable returns true for isDate(), but when I attempt to use .getHour(), .getMinutes()
Timing on Success Message
Is there a way to edit the length the success message stays up after a user submits the form? It disappears in about 3 seconds. please let me know if there is a solution for this.
Creating a data entry table form
Hi I was wondering if Zoho Creator allows to create tables for data entry instead of just single line and multi line in the form builder. For example the highlighted cells below represents the cells to be entered. Regards
Zoho Creator - [Free Webinar] Creator Tech Connect - Release Update Series - Part 3 - 2023
Hello Everyone, We are constantly working towards the platform features to optimise the user experience and to increase the value of the product. As always, our utmost precedence has always been on educating and keeping the users informed about newly
Integreat 05: Integrating Zoho Creator with Zoho Cliq
Hi everyone, This month, we'll look at how to integrate your Zoho Creator application with Zoho Cliq. This is one of the most popular Zoho integrations that our customers use. What is Zoho Cliq? Cliq is a workplace chat application that's part of the Zoho product suite. Integrating with Zoho Cliq You can use this integration to automate processes like posting comments in chat channels or BOT channels. 1. Post a comment in a chat channel in Cliq, directly from Zoho Creator Once you integrate your
Change membership
Bugün bir İçerik Oluşturucu üyeliği oluşturdum ancak ihtiyacım olan üyelik site üyeliği. Planımı değiştirmeme yardım eder misin lütfen?
Next Page